RE: Online recompilation of SP

Your only choice (limited) is do not create standalone procedures ... package them. But Wait there is more ....  

no matter what you create ... procedure/function/package if it is being executed, you can't compile it. Who makes changes in live production environment (other than us) anyways ... ??  

What you want to do is capture ORA-4068 and retry the code that raised the error. Trust me, it is not trivial, especially if it happens when you are in middle of a transaction.  

Raj

Rajendra Jamadagni MIS, ESPN Inc.

Rajendra dot Jamadagni at ESPN dot com

Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!

-----Original Message-----
Sent: Wednesday, January 22, 2003 1:29 AM To: Multiple recipients of list ORACLE-L

Dear all,

Is there any means of changing the body of a SP and recompiling it while there "could" possibly be some sessions accessing it. We have such a req in our appln wherein the recreation shouldn't affect ongoing applns that might access the same SP.

T I A.

Best Regards
Jai

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



text/plain attachment: ESPN_Disclaimer.txt