Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Dynamic procedure calling to solve ORA-4068

Dynamic procedure calling to solve ORA-4068

From: paquette stephane <stephane_paquette_at_yahoo.com>
Date: Wed, 26 Apr 2000 02:22:22 -0700 (PDT)
Message-Id: <10479.104170@fatcity.com>


I'm trying to find a way to solve our ORA-4068 errors.
We have persistent connections and the wonderful world of internet wants us to change the code in production pretty often.

Does someone has done dynamic procedure calling ? My idea is to have a generic procedure (the launcher)that would receive a procedure and its arguments as a in parameter.
If the procedure call failed with an ORA-4068, the launcher would call it again.

Anybody ?



Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50

Do You Yahoo!?
Send online invitations with Yahoo! Invites. http://invites.yahoo.com Received on Wed Apr 26 2000 - 04:22:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US