REPOST: Re: Mistery INSERT satement

From: Erwin Dondorp <ng_at_dondorp.com>
Date: Sat, 29 Dec 2001 17:40:02 +0100
Message-ID: <0$--$$-$$_%%%%_%$$@news.noc.cabal.int>

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?

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: Erwin Dondorp <ng_at_dondorp.com> Newsgroups: alt.config,comp.lang.c,comp.databases.oracle.server Subject: cmsg cancel <3C2DF1E2.507_at_dondorp.com> Control: cancel <3C2DF1E2.507_at_dondorp.com> Date: Mon, 31 Dec 2001 07:00:05 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: <cancel.3C2DF1E2.507_at_dondorp.com> NNTP-Posting-Host: 166.102.15.34 X-Trace: iac5.navix.net 1009788915 26548 166.102.15.34 (31 Dec 2001 08:55:15 GMT) X-Complaints-To: abuse_at_navix.net NNTP-Posting-Date: 31 Dec 2001 08:55: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 Sat Dec 29 2001 - 10:40:02 CST