Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Insert data into multiple tables

user641008May 20 2013 — edited May 21 2013
Hi all,

I've a requirement where i need to insert data into multiple tables using PL/SQL procedure

Procedure should have two parameters
1. Table Name (parameter1)
2. Data (parameter2)

Based on these two parameters i need to insert data into table (parameter1) using data (parameter2)

ex:
Procedure insert_data (p_table  IN VARCHAR2
                      ,p_data   IN -- what should be the datatype?
                      )
IS
l_statement VARCHAR2(2000);
 
BEGIN
-- insert data into tables
INSERT INTO p_table
values (....);
END insert_data;
Thanks in advance!!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 18 2013
Added on May 20 2013
7 comments
638 views