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!