RE: [PL/SQL] INSERT WITH ROWTYPE

Hi=20

This is a 9.2 feature.=20
The correct syntax is: INSERT INTO MYTABLE VALUES vRow;

Chris

>-----Original Message-----
>From: oracle-l-bounce_at_freelists.org =

[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jose Manuel
>Quesada
>Sent: 08 October 2004 13:58
>To: oracle-l_at_freelists.org
>Subject: [PL/SQL] INSERT WITH ROWTYPE
>
>Hi all.
>Environment: Oracle 8.1.7.4
>
>Suppose I have a table MYTABLE with 40 columns.
>
>Is there a way to code in PL/SQL an INSERT statement using a ROWTYPE =
variable.
>
>Something like this:
>---------------------------------------------------
>---------------------------------------------------
>DECLARE
> vRow MYTABLE%ROWTYPE;
>BEGIN
> ...
> ...
> ...
> INSERT INTO MYTABLE vRow;
>END;
>---------------------------------------------------
>---------------------------------------------------
>
>Thanks
>
>--
>http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l