1 Reply Latest reply on Mar 3, 2017 6:01 PM by rareddy

Invoking a JDV Stored procedure with parameters with ODATA

rhn-gps-roridedi Mar 3, 2017 10:17 AM

Hi All,
I created a stored procedure that that has several parameters. What i need clarity on is with is the correct syntax for the odata url when adding parameters.

My current URL looks like:
"localhost:8080/odata/MyStoredProcedure/SchemaName.StoredProcedureName?$SchemaName.StoredProcedureName.ParameterNameOfTypeDate=2014-01-01"

The response i get back is
TEIID30089 Required parameter 'SchemaName.StoredProcedureName.ParameterNameOfTypeDate has no value was set or is an invalid parameter.

I also tried appending a ?$filter= and i recieve thesame error.

I am currently using JDV 6.2.9

1. Re: Invoking a JDV Stored procedure with parameters with ODATA

rareddy Mar 3, 2017 6:01 PM (in response to rhn-gps-roridedi)

If procedure is like

CREATE FOREIGN PROCEDURE getCustomers(OUT p1 boolean, p2 timestamp, INOUT p3 decimal) RETURNS integer;

Then OData URL will be like

/localhost:8080/odata/northwind/getCustomers?p2=datetime'2011-09-11T00:00:00'&p3=2.0M
Actions