Direct Path Loader and temporary tables

[horst borscht]

Hi Marco,

I'm trying to insert records into a global temporary table using TOracleDirectPathLoader.
although "Loader.GetDefaultColumns(False);" works,
"Loader.Prepare;" throws the following error:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
Does TOracleDirectPathLoader have issues with temporary tables?

Thanx in advance and keep up the good work
Horst

 

[Marco Kalter]

We'll check it out. Can you send me the table creation DDL to reproduce this?

 

[horst borscht]

Hi Marco,
Thanks for the quick reaction.
I somehow got it to work...at least the ORA-00942...
not actually sure what the problem was...
basically recreating (create or replace) the synonyms and restarting the Delphi IDE did the trick.
Thought it could have been the problem that i created the synonym for the temporary table using a syntax like
"create public synonym blah for owner.blah;"
because when recreating the synonym i omitted the "owner." portion,
but as i just tested this to verify, it turned out there's nothing wrong with it...
I will post it here if i find out something more specific.

Thanks anyway