SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

insert into ... select from table ... returning bulk collect into

Ward Flores-OracleMay 8 2009 — edited May 8 2009

Hello all,

Trying to execute the following fails with error: SQL command not properly ended. A quick search in the net suggests that this pattern is not supported. However, from the documentation about the returning clause, one may think that this is supported, unless I've misunderstood something.

INSERT INTO emp
SELECT id, name FROM TABLE(l_col)
RETURNING id BULK COLLECT INTO id_list;

Thanks,
wf

[http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/returning_clause.gif]

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 5 2009

Added on May 8 2009

3 comments

2,195 views