ORA-00933 Error with Oracle 7.3

[jbucher]

Hi,
Posting a query with an old Oracle 7.3 i get the above mentioned error. With Oracle 11 i do not have this problem. Using dbMonitor i can only see a "commit"-Transaction but no SQL.
Are there any properties i have to change for Ora 7.3?

Thanks
Juergen

[AlexP]

Hello,

Please specify what an SQL query causes this error?


P.S. Please try to enable the OCI7 mode - OraSession1.Options.UseOCI7 := True;

[jbucher]

Hi Alex,

my SQL: 'Select * from BSOPHTATENSIO where pat_id=25 order by datum desc'

I set in my Connection the property useOCI7 to true. But this does not help.

Juergen

[AlexP]

We cannot reproduce the problem. Please specify the exact version of the Oracle client.

[jbucher]

i use "Direct=TRUE"
OCIW32.dll in the orant/bin-folder is dated: 18.3.1997

[AlexP]

Try to execute this query in the SQLPlus standard utility. If the error doesn't repeat, enable the Debug mode (to enable the Debug mode, add the ODACVcl module to the uses section and set the OraQuery.Debug property to true), and send the query text from the Debug window.