EOracleError at Loader.Prepare after upgrade to 4.0.3 under Oracle 8.1

[indigo]

I upgraded to version 4.0.3 to get the bug fix for Direct Path Loader under Oracle 8.1 causing an ORA-03113 error. After upgrading I can no longer use Direct Path Loader. I now get the following message when Loader.Prepare is executed: Project LoadTable.Exe raised exception class EOracleError with message ". Process stopped. Use Step or Run to continue." After clicking Ok a dialog is displayed with a caption of "Loadtable" but no content. This is consistent with the above message having no text in front of the period. The problem happens in both my application and your demo. Please help ASAP. Thanks, Sidney

 

[Marco Kalter]

What is your Oracle Client and Server version? Can you let me know if it helps when you add or remove the owner from the TableName property (e.g. EMP SCOTT.EMP)?

 

[indigo]

The demo program is running on the test server. Version is release 3 (8.1.7). I ran tablename both ways and each time it failed at execution of Loader.Prepare.

 

[indigo]

I wanted to let you know that if I trap the EOracleError in your demo, I get a null string for E.Message. When I resume I get the following message: Project DirectPath.exe raised exception class Exception with message 'Operation only allowed for prepared TOracleDirectPathLoader'. Process stopped. Use Step or Run to continue.

This message is displayed because Loader.Prepare did not work. I tried to trace into Loader.Prepare but I don't get any code. If I had the source I might be able to help more. Please let me know how to get around this ASAP.

Thanks, Sidney

 

[indigo]

I modified your demo to catch the exception which allows the first run of the benchmark to complete:

// Prepare the loader
try
Loader.Prepare;
except
on E:EOracleError do
begin
ShowMessage(E.Message);
Exit;
end;
end;

However, an attempt to rerun the benchmark results in the following exception at Loader.Prepare:

Project DirectPath.exe raised exception class EAccessViolation with message 'Access violation at address 77F8910E in module 'ntdll.dll'. Read of address 00000014'. Process stopped. Use Step or Run to continue.

Thanks, Sidney

 

[Marco Kalter]

Maybe this problem is specific to this PC? Can you try it on a different PC and/or a different Oracle version?

 

[indigo]

This occurs on the application network server which is 50 miles from here and on my programming computer and test computer. All have Oracle 8.1.7 installed.

DOA version 3.4.6 compiles and runs without the EOracleException problem but has the problem with ORA-03113 that was described as fixed in 4.0.2.

I compiled and copied the two versions of the DirectPath demo version with tablename set to load_file and tablename set to jpso.load_file to the remote server. I ran both via VNC and the problem was identical to my programming and test computers. The E.Message value after the EOracleException is blank but fatal. It occurs at execution of Loader.Prepare.

 

[indigo]

I reinstalled the 3.4.6 version and both the demo and my application programs work again. I still need the fix for the ORA-03113 error that 4.0.3 was to provide.

 

[Bob Molinelli]

I am having the same problem after upgrading to the new version (4.06) using Delphi 6. I get the ORA-03113 error during the prepare. If I add the table owner name I get a ORA-024329 error. The oracle server is 8i. Your previous version worked great. Is there a fix for this yet?

Thanks

 

[Marco Kalter]

What was your previous version?