Re: Problem with trigger/sqlca.sqlerrd[2]

I completely forgot about insert ... returning (Thanks asktom)

declare
l_id pls_integer;

begin
insert into parent( id, ... ) values ( my_parent_seq.nextval, ... ) returning ID into l_id;
dbms_output.put_line( 'the new row is ' || l_id ); end; Received on Thu Mar 09 2006 - 20:02:38 CST