Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: calling stored procedures dymanic
DBMS_SQL works also for stored procedure calls
Bernhard Riehm wrote in message <7obms3$c5v$1_at_black.news.nacamar.net>...
>Hello,
>
>I want to create a trigger for a table.
>This trigger should call a stored procedure,
>which name is generated at runtime.
>At designtime of the trigger, I don't know all
>possible stored procedure calls.
>It is necessary that we can add stored procedures dynamically,
>and they should be called by the trigger.
>With DBMS_SQL I can only generate
>dynamic SQL-Statements.
>Is there a way to generate stored procedure calls?
>
>Bernhard Riehm,
>perbit Software GmbH.
>
>
>
>
Received on Thu Aug 05 1999 - 05:36:35 CDT