Question about TOracleDirectPathLoader

[tstenstrom]

This is just a general question before I dig deeper into my problems with TOracleDirectPathLoader.

When I use 10.2 DB and 10.2 client everything works like a charm but with 9.2 DB and 10.2 client, prepare crashes.

Is this likely to be a DOA- or an ORA-problem?

I'm using DOA 4.0.6.2

Best Regards

Torbjorn Stenstrom

 

[Marco Kalter]

It's most likely an Oracle Client issue (since that is the variable here). Can you let me know the error message of the crash?

 

[tstenstrom]

Hi Marco,

I receive the ORA-00942 'Table or view does not exist'. Can this be a permission problem? The user sees the user_objects and I can do a 'GetDefaultColumns' so that is working but can anyone tell me if there are some special permissions for the loader to work?

Best Regards

Torbjorn Stenstrom

 

[Marco Kalter]

This happens during the Prepare call? In that case I can only imagine that the table specified in the TableName property is not accessible within the Session to which the loader instance is attached.

 

[deanbrown3d]

I am seeing precisely the same error and under the same conditions (10g client, 9.2 server), same error message, whereas it all works fine under 10g client with 10g server. I hope this can be resolved soon as people move over to 10g during the next year or two.

Dean