From dgoulet@vicr.com Sat, 17 Mar 2001 06:54:37 -0800 From: dgoulet@vicr.com Date: Sat, 17 Mar 2001 06:54:37 -0800 Subject: Re: when does 'ora-1007 variable not in select list ' occur Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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 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@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@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@vicr.com 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@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).