Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: inserting records from a table to another using %rowtype

Re: inserting records from a table to another using %rowtype

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 16 May 2005 17:09:07 +0200
Message-ID: <1qdh81t7co0rvcpgls43a21vjhd7p6k832@4ax.com>


On 16 May 2005 08:02:59 -0700, "swoop" <carl.barrett_at_newcastle.gov.uk> wrote:

>Here is the code I have so far. The error I get is on line 15 (FOR
>rec1 in ab_cur)
>
> *
>ERROR at line 15:
>ORA-06550: line 15, column 13:
>PLS-00103: Encountered the symbol "AB_CUR" when expecting one of the
>following:
>(
>
>I hope someone can help.

No version! Why is it so extreemly difficult to post the version? Why does everyone assume everyone is using *their* version. Most answers are version dependent, including this one. 8i (desupported): not possible
9i,10g: possible.

--
Sybrand Bakker, Senior Oracle DBA
Received on Mon May 16 2005 - 10:09:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US