We are having a requirement where list of procedures need to be created by another procedure.

Any pointers how to do so.

TIA
Sippy

Hi,
Please test with CREATE PROCEDURE FROM....

Gustavo.

We have a specific requuirement.
I'm trying to create/alter tables procedured through script. Script in turn will create a sql file with all necessary statements. From script one standard procedure will be created with sql statements in the file as body. If the sql statements in temprray file contains the create procedure then thsi is not working.

TIA,
Sippy