Re: Cannot compile Function for Lock issue!

From: vipan <dba_at_no_spam.netscape.net>
Date: Wed, 13 Aug 2003 14:42:49 +0530
Message-ID: <3F3A0111.9050001@no_spam.netscape.net>

Hi,

Before compiling the funciton you can query v$access view and come to know wheather your function is getting used at that time.

Thanks

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!
Received on Wed Aug 13 2003 - 04:12:49 CDT