Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Mistery INSERT satement
Hi Kan,
can you please show the structure of TAB1 and the full statements without dots and the respective error message? I do not believe that your description is complete and correct.
Regards,
Martin
Kan wrote:
>
> Hi all,
>
> I have very strange situation and wondering if somebody have something like
> this earlier.
> If I run next statement
>
> INSERT INTO TAB1 (COL1, COL2, .., COLN) VALUES (VAL1, VAL2, .., VAL3)
>
> everything is OK, But if I run the same statement like this
>
> BEGIN
> INSERT INTO TAB1 (COL1, COL2, .., COLN) VALUES (VAL1, VAL2, .., VAL3);
> END;
>
> I got next error:
>
> PLS-0039: undefined column 'COLN' in INSERT statement.
>
> Note: N = 23.
>
> Does anybody had something like this befor?
>
> Thanks to all
Received on Fri Dec 28 2001 - 04:19:24 CST