ora-936 and SQL*Loader
From: <genegurevich_at_discover.com>
Date: Mon, 16 Jun 2008 12:15:07 -0500
Message-ID: <OF947BBF8D.97BACEE2-ON8625746A.005E401F-8625746A.005EC606@discover.com>
Date: Mon, 16 Jun 2008 12:15:07 -0500
Message-ID: <OF947BBF8D.97BACEE2-ON8625746A.005E401F-8625746A.005EC606@discover.com>
Hi all:
I'm trying to find out what could be causing ora-00936 when SQL*Loader process is running against a table in direct mode. The database is 10.2.03, the clinet is 9.2
I am seeing these errors:
SQL*Loader-951: Error calling once/load initialization ORA-02373: Error parsing insert statement for table NADV.XCHG_AUTH. ORA-00936: missing expression
The script is generated by Ab Initio (1.14.3.3) and out of many tables this particular one is failing. I have searched Metalink, but did not find anything resembling my issue. If anyone have dealt with this , please share with me
thank you
Gene Gurevich
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 16 2008 - 12:15:07 CDT