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.
Thanks
Brian
--
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.
