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

Home -> Community -> Usenet -> c.d.o.server -> Re: Cannot compile Function for Lock issue!

Re: Cannot compile Function for Lock issue!

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 13 Aug 2003 20:16:29 +0200
Message-ID: <920ljvk625aob12aabbt0fr23cr8bkihqn@4ax.com>


On 13 Aug 2003 01:15:49 -0700, ccwei_at_ms1.pchome.com.tw (Alvin) wrote:

>Hi
>
>I've a stored function called by a lot of procedures and those procedures
>
>were run by different schedule(15 mins/1 hour,....).
>
>Everytime I want to compile the function, it was locked and hanged.
>
>My workaroud is to create a new one, it's stupid. But what can I do.
>
>Could I know whether the function was called or not at a specific time.
>
>Best Regards
>
>Alvin Liu!

Guess you are changing functions in a production environment outside the maintenance window. That is just a grave sin. Any reason why you want to commit that crime?

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Aug 13 2003 - 13:16:29 CDT

Original text of this message

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