Re: when does 'ora-1007 variable not in select list ' occur

From: <dgoulet_at_vicr.com>
Date: Sat, 17 Mar 2001 06:54:37 -0800
Message-ID: <F001.002CFE1E.20010317063524@fatcity.com>

Grace,

This is normally a programming error in that you have more host variables than columns in the select list.

Dick Goulet

Reply Separator ---------------------- Author: grace lim <mglim_at_softhome.net> Date: 3/16/01 6:50 PM

hi gurus,

in what instances 'ora-1007 variable not in select list ' occurs?

i'm having difficult in tracing the cause of it in my process. because when
i rerun the process w/ the same data set. it didn't occur again.... it's very intermitent.

thanks
Best regards,
Grace Lim
Suy Sing Comm'l Corp.
(063)-02-247-41-34
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: grace lim
INET: mglim_at_softhome.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------