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

[Message index]

		ODBC log shows ORA error even though the procedure runs fine on the backend. By: shr1975 on Thu, 29 October 2009 02:53
		Re: ODBC log shows ORA error even though the procedure runs fine on the backend. By: Michel Cadot on Thu, 29 October 2009 03:19
		Re: ODBC log shows ORA error even though the procedure runs fine on the backend. By: shr1975 on Fri, 30 October 2009 01:24
		Re: ODBC log shows ORA error even though the procedure runs fine on the backend. By: shr1975 on Fri, 30 October 2009 01:26
		Re: ODBC log shows ORA error even though the procedure runs fine on the backend. By: Michel Cadot on Fri, 30 October 2009 02:57
		Re: ODBC log shows ORA error even though the procedure runs fine on the backend. By: shr1975 on Fri, 30 October 2009 05:03
		Re: ODBC log shows ORA error even though the procedure runs fine on the backend. By: Michel Cadot on Fri, 30 October 2009 05:16

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: Wed Apr 24 15:02:49 CDT 2024