Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Mistery INSERT satement
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 - 01:56:57 CST