Skip to Main Content

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 With RETURNING INTO...

EyesJun 11 2004 — edited Jun 11 2004
FUNCTION addNewRow(aTable IN VARCHAR2,
aCols IN VARCHAR2,
aValues IN VARCHAR2)
RETURN tc_ResultSet IS

v_sql VARCHAR2(2000);
vc_ResultSet tc_ResultSet;
v_rowID UROWID;

BEGIN

v_sql := 'INSERT INTO ' || aTable ||' (:a) VALUES (:b) RETURNING rowid INTO :c';
EXECUTE IMMEDIATE v_sql USING aCols, aValues RETURNING INTO v_rowID; <<<<<----- ERROR ORA-00928 missing SELECT keyword

v_sql := 'SELECT * FROM ' || aTable || ' WHERE ROWID = :d';
OPEN vc_ResultSet FOR v_sql USING v_rowID;

RETURN(vc_ResultSet);

END addNewRow;


First, This are my function, because I unkown how returning the new's record...
Second, if I can't Returning the new's record it's the better solution??? or what can I do???

Thanks!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 9 2004
Added on Jun 11 2004
6 comments
2,939 views