Hi, hope this hasnt been answered too many times before...
I want to write a stored procedure to insert a record into a table (the key field being derived from a sequence) and return the sequence value via an out parameter to the stored procedure.
What I am trying to achieve is something like...
(OUT_ID_NO Out Number) IS
INSERT INTO T_MYTABLE (ID_NO)