Re: PL/SQL Numeric error in calling proc from VB5-ADO

In article <8oj1jn$4j04_at_eccws12.dearborn.ford.com>,   "Fred Rinehart" <frinehar_at_ford.com> wrote:
> I am calling a proc within a package from VB5 using ADO and the
 Microoft
> ODBC for Oracle driver.
> The proc checks a users Oracle roles for security checking.
> The proc runs fine for weeks on end but then suddenly returns the
 Oracle
> error: "PL/SQL or Numeric error" upon someone accessing it.
> All subsequent calls to it receive the same error and all connections
 are
> locked. The proc can be run through SQLPlus without a problem.
> The database must be recycled to free it.
> I am reusing the connection object for the entire session, is this a
> problem?.
> Has anyone encountered this message before? Am I exceeding an Oracle
> connection limitation? ADO limitation?

So you have an open connection to the database for weeks on end? I don't know of any reason that this shouldn't work, though it's not something I've got a lot of experience with.

• What happens if you use a different ODBC driver (i.e. the Oracle ODBC driver)?
• Does your ASP code handle the case where a connection is unexpectedly dropped by the database? If the driver signals that a connection has been dropped but the application continues to issue commands, bad things generally occur.

Justin Cave
Oracle ODBC Development

Opinions expressed herein are my own and may not reflect those of Oracle Corporation.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Aug 30 2000 - 19:42:02 CDT