%ROWTYPE and INSERT

Hi to all,

I was just wondering if someone else has a solution or maybe a comment to the following:

In PL/SQL Version 2.3.2.0.0 is possible to declare rowtype's using the %ROWTYPE syntax when creating a new variable. It is then possible to fetch rows from the table directly in this variable without having to define each column of the table.

This is extremely nice to use and we use it extensively.

Unfortunately it is not possible to use the same %ROWTYPE variables for INSERT and UPDATE statements that affect all columns of a table.

Is this functionality available? If not, why did Oracle not implement this? Does Oracle plan to add this functionality?

Thank you for any comments

Dieter Oberkofler
Director of Engineering

LEADING BITS GmbH.               Tel             (+43-1) 586 76 11
Schleifmuehlgasse 5/17           Fax             (+43-1) 587 76 15
A-1040 Vienna                    E-mail     dtr_at_leadingbits.via.at
Austria                          Compuserve            100141.1314


------------------------------------------------------------------