10G client talking to 9i DB with SQL LOADER using the direct load option

From: Wolfson Larry - lwolfs <lawrence.wolfson_at_acxiom.com>
Date: Wed, 17 Oct 2007 15:19:19 -0500
Message-ID: <B39B7B7D8C8CEA419D0ED45FD7FA4C53027D2F6D@CWYMSX06.Corp.Acxiom.net>

HI Guys,

                I've got an app server with a 10G client.  The app guys

what to use the direct load option with SQLLOADER going to a 9I DB.

Seems the 10G view has an extra column in it that 9i doesn't have.

Is there a way around this without installing a 9i client or using a conventional load as OSS says is the solution?

Like changing the 9i view just for this user?

Here are the error message that are getting generated when we invoke sqlloader using the direct load option.

ORA_F901,0: SQL*Loader-925: Error while uldlpim: OCIStmtExecute

ORA_F901,0: ORA-00904: "MESSAGE_NUM": invalid identifier

Using the conventional load returns no error.

TIA Larry

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.

If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.

If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.

Thank you.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Oct 17 2007 - 15:19:19 CDT