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>

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 ( 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

Received on Mon Jun 16 2008 - 12:15:07 CDT

Original text of this message