Hi,

Is it possible in one Stored Procedure to get the auto generated key
for a row?

I've this procedure:

begin
INSERT INTO PLANSESSIONS ( SESSION_INFO )
VALUES ( :SESSIONINFO );
suspend;
end

But would like to get directly the autogenerated key 'SESSION_ID'.
How can I do this?

Thanks,
Tom.