Executing a procedure from within another procedure dynamically

From: Don Del Grande <del_grande_at_netvista.net>
Date: Wed, 24 Nov 1999 17:59:58 GMT
Message-ID: <81h92r$4jn$1@nnrp1.deja.com>

I'm using V7.3. Is there any way to call a stored procedure from within another stored procedure WITHOUT hard-coding the name in the first stored procedure?

I tried:
DBMS_SQL.PARSE(c, 'EXECUTE ' || procedure_name, DBMS_SQL.v7) ("c" is the return value from an OPEN_CURSOR; "procedure_name" is a VARCHAR2 containing the name of an existing procedure) but it returned an ORA-00900 error ("Invalid SQL statement").

---

Sure, the Navy could maintain its own news servers, or we could save the money and pass the savings onto the taxpayers (or, for example, certain taxpayers planning on running for the Senate in New York) by using...

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 24 1999 - 11:59:58 CST