Re: Stored Procedure & user exits ????
From: Carl Gohringer <cgohring_at_lucifer>
Date: Tue, 20 Sep 1994 08:40:53 GMT
Message-ID: <CwF6s5.J3E_at_nl.oracle.com>
Date: Tue, 20 Sep 1994 08:40:53 GMT
Message-ID: <CwF6s5.J3E_at_nl.oracle.com>
ai178_at_FreeNet.Carleton.CA (Ian Abramson) writes:
:
:
: I have a question. Is there any way that a user exit can be
: called from a stored procedure that is ONLY going to be called from a Form?
On the client side, you can link your user exit into a PRO*C program. You can then have the PRO*C program wait on a pipe(the DBMS_PIPE package). You can then have database side PL/SQL(trigger, procedure etc) send a message down the pipe to the sleeping PRO*C program via DBMS_PIPE, and the C program can then perform whatever operation specified by the message.
-- regards, Carl +-----------------------------------------------------------------------------+ Carl Gohringer, Oracle UK, The Oracle Centre, The Ring, Bracknell, Berkshire, England, RG121BW Internet : cgohring_at_uk.oracle.com +-----------------------------------------------------------------------------+Received on Tue Sep 20 1994 - 10:40:53 CEST