Skip to Content
avatar image
Former Member

Invoke Oracle Stored Procedure

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 08, 2007 at 06:36 PM

    Ryan,

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

    Regards,

    Salvatore Castro

    Sr. Solution Architect

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 08, 2007 at 07:18 PM

    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

    Add comment
    10|10000 characters needed characters exceeded