Invoke Oracle Stored Procedure

[Former Member]

I have inherited an Oracle Stored procedure (call it FOO) that takes two parameters: a "serial number" and a cursor. If I read the documentation correctly, I should be able to create a FixedQueryWithOutput whose "query" is

           call owner.FOO( 'serialNumberValue', ? )

And the "Test" button should run this query, and return the output of the query. Instead, I get a..

      No more data to read from socket

..error. What am I missing?

[Former Member]

I assume that the Oracle Stored Procedure is returning a REF CURSOR as the output? What if you hard-code the serial number parameter in the stored procedure - do you get and output using call owner.FOO( ? ) ?

Joe

[salvatore_castro]

Ryan,

Use FixedQuery and the syntax for your expression is the same as an valid SQL statement.

Regards,

Salvatore Castro

Sr. Solution Architect