Home -> Usenet -> comp.databases.oracle -> generate a stored procedure using another stored procedure

generate a stored procedure using another stored procedure

From: Murali <murali_l_1729_at_yahoo.com>
Date: 21 Feb 2003 09:22:18 -0800
Message-ID: <2cc5f0be.0302210922.6b9f8631_at_posting.google.com> 






I want to create stored procedure dynamically from a mapping table. 
Here is how my "mappingTable" table looks:




Plan, ObjectId, ObjectKey, ObjectAttribute, tableName
Plan1  name     John Doe   SSN              Employee




My aim is to create a stored procedure (say proc1) which has a series
of Insert and update statements which would like this:





Insert into myTable (SSN) Select SSN from Employee where name = 'John
Doe'





I want this "proc1" to be generated by another procedure by reading
data from the mapping table above.  I am running into problems with
maximum length of a line to be 255 when i try to generate this using
the DBMS_OUT utility.



Is there a way around this?  Or is there a utility that can help me do
this.


I would prefer to not write Java code that would read data and do
this. I would like all of this to be preferably be inside the database
(oracle 8.1.7)



Thanks a lot for your help.
Received on Fri Feb 21 2003 - 18:22:18 CET












Original text of this message