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

Home -> Community -> Usenet -> c.d.o.tools -> Question: How can I dynamically call stored procedures in Oracle 8?

Question: How can I dynamically call stored procedures in Oracle 8?

From: Kevin <kevinw1_at_mindspring.com>
Date: 2000/07/07
Message-ID: <Abr95.102988$5k2.217088@dfw-read.news.verio.net>#1/1

I have a table which contains stored procedure names. I want to build a cursor that calls each of these stored procedures. How can I execute a stored procedure when I have its name stored in a variable?
I've tried:

BEGIN variable; END;

and this doesn't work. In MS SQL Server, you can do this with the following code:

EXECUTE variable.

Any help would be appreciated. Received on Fri Jul 07 2000 - 00:00:00 CDT

Original text of this message

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