Home » Open Source » Programming Interfaces » ODBC log shows ORA error even though the procedure runs fine on the backend. (Oracle 9i with Windows 2000 server.)
icon5.gif  ODBC log shows ORA error even though the procedure runs fine on the backend. [message #428617] Thu, 29 October 2009 02:53 Go to next message
shr1975
Messages: 4
Registered: October 2009
Junior Member
We are using Oracle 9i client on a Windows 2000 server and using a DSN created with Microsoft ODBC for Oracle driver.

We have a PL/SQL procedure that runs fine when executed directly on the backend.

However, when it is called through our application (.net 1.1), it gives an ORA-06502 error and this shows in the ODBC log.

What could be the problem?
Re: ODBC log shows ORA error even though the procedure runs fine on the backend. [message #428621 is a reply to message #428617] Thu, 29 October 2009 03:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I advice you to use Oracle driver.

Regards
Michel
icon5.gif  Re: ODBC log shows ORA error even though the procedure runs fine on the backend. [message #428784 is a reply to message #428621] Fri, 30 October 2009 01:24 Go to previous messageGo to next message
shr1975
Messages: 4
Registered: October 2009
Junior Member
Thanks Michel.

I tried using the Oracle ODBC driver. But I am getting this following error in my application log:
Error Source: [FTI.Common.BF.DBAccessors.DBAccessOdbc] Message:[ Odbc Exception Information:
Description:[Message: [Oracle][ODBC][Ora]ORA-06550: line 1, column 41:
PLS-00201: identifier 'BOOKID' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Native: 6550
Source: SQORA32.DLL
SQL: HY000
]

This happens with both, 9i and 10g drivers.
Re: ODBC log shows ORA error even though the procedure runs fine on the backend. [message #428785 is a reply to message #428784] Fri, 30 October 2009 01:26 Go to previous messageGo to next message
shr1975
Messages: 4
Registered: October 2009
Junior Member
Please note that the source of the error is SQLORA32.dll
Re: ODBC log shows ORA error even though the procedure runs fine on the backend. [message #428813 is a reply to message #428784] Fri, 30 October 2009 02:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The query you are sending contains an error.
Either the identifier does not exist either you ave no access right on it.

Regards
Michel
Re: ODBC log shows ORA error even though the procedure runs fine on the backend. [message #428834 is a reply to message #428813] Fri, 30 October 2009 05:03 Go to previous messageGo to next message
shr1975
Messages: 4
Registered: October 2009
Junior Member
As I had mentioned in my very first post, this procedure runs fine when run on the back-end directly (i.e. through Toad or SQL/Plus).

Also, this runs fine with Microsoft ODBC driver on some machines, but on some machines this gives an ORA-06502 error.

When I tried with Oracle ODBC driver, I got ORA-06550 error.
Re: ODBC log shows ORA error even though the procedure runs fine on the backend. [message #428840 is a reply to message #428834] Fri, 30 October 2009 05:16 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It does not change the answer.
Something is different between the 2 cases but as you didn't post no information you can't have more help.

Regards
Michel
Previous Topic: Oracle 10.2 Startup /Shutdown via JDBC
Next Topic: Unable to change Oracle SID with Net::SSH::Perl
Goto Forum:
  


Current Time: Thu Mar 28 18:57:43 CDT 2024