Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: calling stored procedures dymanic

Re: calling stored procedures dymanic

From: Philippe <parnaud_at_yahoo.com>
Date: Thu, 5 Aug 1999 12:36:35 +0200
Message-ID: <7obpg7$9p0$1@concorde.ctp.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US