DBMS_SQL package problem with cmd : inert into ... returning var into :desc

I would like to execute an insert returning command like this :

    INSERT INTO table (var1, var2, ...) VALUES (val1, val2, ...) RETURNING var1 INTO :desc

I want to use DBMS_SQL package with BIND_VALUE and VARIABLE_VALUE to execute this command but oracle server answer with error n°1427.

Does anyone has a solution for me.

Thank you, Franck. Received on Fri Feb 12 1999 - 09:30:13 CST