Re: RESTRICTED PROCEDURE

From: Nobody <nobody_at_yahoo.com>
Date: Fri, 8 Oct 1999 17:51:02 +0800
Message-ID: <37fdbe6b@ruby.hknet.com>

You cannot use certain restricted procedures in some triggers. It's a Oracle design. However, you can bypass it by the followings : (1) In your trigger (e.g. ON-DISPATCH-TRIGGER), creates and expires a timer. (2) When the timer expires, call restricted built-ins like GO_BLOCK.

However, unexpected result may arise because it's not a Oracle standard. Please post to see whether it works.

Hope this helps.

Graziano <gcaforio_at_formanet.it> wrote in message news:7tk9ip$hbh$1_at_fe2.cs.interbusiness.it...
> How I can use GO_BLOCK and EXECUTE_QUERY in ON-DISPATCH-TRIGGER?
> Thanks for any answer.
>
> --
>
> --------------------------------------------------------------------------
-
> Rag. Caforio Graziano
> Engineering Software
> Via G.ppe Pietroforte, 25
> 70021 Acquaviva d. Fonti (BA)
>
> gcaforio_at_formanet.it
> gcaforio_at_libero.it
> ICQ#29620328
> --------------------------------------------------------------------------
-
>
>
Received on Fri Oct 08 1999 - 04:51:02 CDT