Re: Mistery INSERT satement

Kan wrote:
 > [shortened]

> 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.

Is TAB1 a true table, or a view or synonym? Does it help to add the schema/owner name in front of TAB1?

E. Received on Sat Dec 29 2001 - 10:40:02 CST