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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
