REPOST: Mistery INSERT satement

From: Kan <deberni_at_yahoo.com>
Date: Fri, 28 Dec 2001 08:56:57 +0100
Message-ID: <4$--$$-$$_%__$%$%$@news.noc.cabal.int>

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

WAS CANCELLED BY =======: Path: news.sol.net!spool1-nwblwi.newsops.execpc.com!newsfeeds.sol.net!news-out.visi.com!hermes.visi.com!uunet!ash.uu.net!sac.uu.net!lax.uu.net!news.navix.net!u-n-c-a-n-c-e-l-l-e-r From: "Kan" <deberni_at_yahoo.com> Newsgroups: alt.config,comp.lang.c,comp.databases.oracle.server Subject: cmsg cancel <a0h8fm$511$1_at_news.onet.pl> Control: cancel <a0h8fm$511$1_at_news.onet.pl> Date: Mon, 31 Dec 2001 06:02:28 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: <cancel.a0h8fm$511$1_at_news.onet.pl> NNTP-Posting-Host: 166.102.15.34 X-Trace: iac5.navix.net 1009790175 28060 166.102.15.34 (31 Dec 2001 09:16:15 GMT) X-Complaints-To: abuse_at_navix.net NNTP-Posting-Date: 31 Dec 2001 09:16:15 GMT X-No-Archive: yes Comment: Anarchy! Fuck You! X-Commentary: I love NewsAgent 1.10, Sandblaster Build 74 (19 March 1999) and the Polaris Cancel Engine V. 6.1 X-Unacanc3l: yes

This message was cancelled from within Mozilla...not Received on Fri Dec 28 2001 - 01:56:57 CST