OraFAQ Forum: Programming Interfaces » ODBC log shows ORA error even though the procedure runs fine on the backend.

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.)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ODBC log shows ORA error even though the procedure runs fine on the backend. [message #428617]

Thu, 29 October 2009 02:53

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?

Report message to a moderator

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

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I advice you to use Oracle driver.

Regards
Michel

Report message to a moderator

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

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.

Report message to a moderator

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

shr1975
Messages: 4
Registered: October 2009

Junior Member

Please note that the source of the error is SQLORA32.dll

Report message to a moderator

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

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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.

Report message to a moderator

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

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 09:03:31 CST 2025