OAS 3.0 Stored Procedure Errors

From: <busch1_at_llnl.govX>
Date: 13 Jun 1998 00:03:06 GMT
Message-ID: <6lsfjq$o72$1@lll-winken.llnl.gov>

When running a stored procedure through the Oracle Application Server which is marked as 'INVALID', the user gets a message ORA-01455 Invalid Number or ORA-01013 insufficient privilege.

SQL*Plus will auto-recompile procedures which have become invalid when the procedure is called. The Oracle Application Server will not.

So if a stored procedure is called when a database link is down, the procedure cannot be run until it is recompiled, even if the database link is up. Result: lots of user calls.

Oracle Support doesn't see this as a problem.

Comments?

---
Jeff Busch Email: busch1_at_llnl.govX Phone: (925) 423-9134 Received on Fri Jun 12 1998 - 19:03:06 CDT