Simon,
3) my syntax is 100% correct.
Excuse me, but I must be missing something. You wrote:
syntax is 'return X into ?' in oracle.
But the following example is taken from the
Oracle9i SQL Reference
Inserting Using Bind Variables: Example
The following example returns the values of the inserted rows into output
bind variables :bnd1 and :bnd2. (The bind variables must first be
declared.)
INSERT INTO employees
(employee_id, last_name, email, hire_date, job_id, salary)
VALUES
(employees_seq.nextval,'Doe','john.doe@oracle.com',SYSDATE,'SH_CLERK',2400)
RETURNING salary*12, job_id INTO :bnd1, :bnd2;
Your syntax doesn't look the same as Oracle's, although when I tested your syntax, it worked. So why is
RETURN allowed when the documentation uses
RETURNING?
(Since you "make your own", I won't wish you...)
Good Luck,
Avi.