Page 1 of 1
ORA-00933 Error with Oracle 7.3
Posted: Wed 20 Aug 2014 06:08
by 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
Re: ORA-00933 Error with Oracle 7.3
Posted: Wed 20 Aug 2014 12:12
by AlexP
Hello,
Please specify what an SQL query causes this error?
P.S. Please try to enable the OCI7 mode - OraSession1.Options.UseOCI7 := True;
Re: ORA-00933 Error with Oracle 7.3
Posted: Wed 20 Aug 2014 15:43
by 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
Re: ORA-00933 Error with Oracle 7.3
Posted: Thu 21 Aug 2014 08:13
by AlexP
We cannot reproduce the problem. Please specify the exact version of the Oracle client.
Re: ORA-00933 Error with Oracle 7.3
Posted: Mon 25 Aug 2014 06:57
by jbucher
i use "Direct=TRUE"
OCIW32.dll in the orant/bin-folder is dated: 18.3.1997
Re: ORA-00933 Error with Oracle 7.3
Posted: Tue 26 Aug 2014 08:43
by 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.