On Feb 26, 12:51 pm, zarnce <[email protected]> wrote: > I have a stored procedure that returns a value by an out parameter. > Is it possible to get the value using call_sproc? I am using Oracle > with the JDBC driver. > > Example Stored Proc: > PROCEDURE create ( > VALUE_IN IN VARCHAR2, > KEY_OUT OUT NUMBER > ) > IS > BEGIN > INSERT INTO MYTABLE (VALUE) VALUES VALUE_IN > RETURNING KEY INTO KEY_OUT; > END; > > This should return the generated KEY when the stored proc is called. > I successfully make the call, the row is added, but I don't get/know > how to get the value back.
Sequel doesn't currently support this. Currently, you have to get the stored procedure to return a single row and a single value. I'll accept a patch to the JDBC adapter to add support for out parameters. Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
