posted 15 years ago
Hi,
I want to read all the tables from a schema, and read all columns for the particular table, based on the column datatype and its length i need to insert the values .
Ex:
wil return all the tables, from the result i need to loop the resutset
procedure for INSERTRECORDS:
------------------------------------
Problem:
From the 1st procedure im getting each table and pass the value to second procedure. From the second procedure with in the cursor i need to get all the columns
in a single step, so that i can insert values into table ..
Warm Regards,
Thirumurugan Sivaji