Re: Stored procedure for trigger code

>Hi,
>
>I'm trying to find a way to store the code behind a When-Button-Pressed
>trigger in a procedure but the documentation I've looked at is pretty
>vague. Does anyone have any ideas about how I could set up a procedure
>for this? I'd rather write (copy/paste) the code once and then
>reference it in a call to a stored procedure.
>
>Thanks in advance.
>--
>Jason Mackay
>Sys Admin/System Analyst
>Nu-Pharm Inc.
>Richmond Hill, Ontario, Canada
>jmackay_at_nu-pharm.com
>
>
If you have the form, the code is in the WHEN-BUTTON-PRESSED PL/SQL in the form. If you put it in a form procedure, you can move this directly to the DB by simply dragging the form procedure to the 'Database Objects' part in the object navigator (to the correct Oracle account). This will only work though, if the procedure makes no reference to screen variables (or :parameter, or :system variables)

If this is calling a procedure on the DB, look in the table USER_SOURCE under the appropriate schema.

DanHW Received on Fri Nov 28 1997 - 00:00:00 CET