DirectPathLoader - Table or view not exists

Del

Member
I use DirectPathLoader, on calling Prepare - error: "Table or view not exists". Table exists - I check it. Same code:

Code:
Loader := TOracleDirectPathLoader.Create(nil);
   Loader.Session := DM.OSs;
   Loader.TableName := 'OSA_CELLS_TMP';
   Loader.GetDefaultColumns(False);
   Loader.Prepare;
Dm.OSs.Connected = True. Logon information fro DM.OSs is valid. For experiment I write before "Loader := TOracleDirect..." this:

Code:
with TOracleQuery.Create(Self) do
try
  Session := DM.OSs;
  SQL.Text := 'select * from OSA_CELLS_TMP';
  Execute;
  Close;
finally
  Free;
end;
This code work with no errors. Then I check Loader.Columns[0].Name (before "Prepare", after "GetDefaultColumns") - all right, columns was loaded succes. But on "Prepare" Loader faults with message "Table or view not exists".
Plz, help! Where is a bug?
 
Can you include the table owner and try again? For example 'SCOTT.OSA_CELLS_TMP' instead of 'OSA_CELLS_TMP'?
 
I try it, thanks. But I have the same result - "ORA-00942: table or view does not exist". I try use another server - Oracle 10 (was 9) with similar table. Work all right. But I need also work with Oracle 9 :(
 
Back
Top