INSERT and the RETURNING Clause

[amauer]

Can more than one value be returned in the RETURNING clause? Tried "RETURNING a INTO :a, b INTO :b" but Oracle didn't like it.

Thanks

 

[foldenm]

Try using the following syntax:
INSERT INTO MYTABLE(a,b,c)
VALUES(1,2,3)
RETURNING a,b,c INTO :v1,:v2,:v3;

Originally posted by amauer:
Can more than one value be returned in the RETURNING clause? Tried "RETURNING a INTO :a, b INTO :b" but Oracle didn't like it.

Thanks

 

[amauer]

Thanks, I'll try it.