Stored Proc in table

From: Dirk <dirk02_at_my-deja.com>
Date: 29 Aug 2002 00:58:52 -0700
Message-ID: <d52106cc.0208282358.53487246@posting.google.com>

Hi,

i want to have a table with different stored procedures like this:

id      call
1       sp_test.generatesomething
2       sp_test.insertthis

How can i call this procedures from a stored procedure? And how can i pass parametersm to the selected stored proc. ? How can i handle inout-parameters?

Can i do this by dynamic sql (execute immediate) like this?
...

EXECUTE IMMEDIATE '
DECLARE
  IPara1 VARCHAR2(3);
  OANRID NUMBER;
  OACTION NUMBER; BEGIN
  IPara1 := NULL;
  OANR := NULL;
  OACTION := NULL;   APSDBA.SP_Test.generate ( IPara1, OANR, OACTION );   COMMIT;
END; '
into out1, out2;
...

tia,

Dirk Received on Thu Aug 29 2002 - 02:58:52 CDT