6 Replies Latest reply on Feb 19, 2009 7:03 AM by Steve Bishop

    Call stored procedure with OUT parameter

    Level 1

      I have created a short-lived process. Within this process I am using the "FOUNDATION > JDBC > Call Stored Procedure" operation to call an Oracle procedure. This procedure has 3 parameters, 2 IN and 1 OUT parameter.

      The procedure is being executed correctly. Both IN parameters receive the correct values but I am unable to get the OUT parameter's value in my process.

      Rewriting the procedure as a function gives me an ORA-01460 since one of the parameters contains XML (>32K) so this is not option...

      Has someone been able to call a stored procedure with an OUT parameter?