This is an idea for an enhancement to the PL/SQL syntax.
If I have the following declaration:
DECLARE in_record mytable%ROWTYPE; out_record mytable%ROWTYPE; BEGIN
I can do this:
INSERT INTO mytable VALUES in_record;
I can also do this:
UPDATE mytable SET ROW = in_record WHERE ...;
I can do this, as long as I list each and every column, in the right order:
INSERT INTO mytable VALUES in_record RETURNING cola, colb, colc INTO out_record;
But I can’t do this:
INSERT INTO mytable VALUES in_record RETURNING ROW INTO out_record;
Can we make this happen, Oracle?