Re: generate a stored procedure using another stored procedure

Use shell to produce a sql script and run it. But for the performance, this should be a tool used by only few people. Don't give it to users.

On 21 Feb 2003 09:22:18 -0800, murali_l_1729_at_yahoo.com (Murali) wrote:

>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 Sat Feb 22 2003 - 15:48:51 CET