Invoking a JDV Stored procedure with parameters with ODATA

Latest response

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

Responses

Hello Rahman,

It looks like your issue has been resolved on the JBoss community thread here: https://developer.jboss.org/thread/274200

If this is not the case and you have a Red Hat support subscription, you can use the formal support channels for help.

Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.