Re: insert into table , where the table name is a parameter

From: Michael Kuznetsov <mvk_at_servocomp.ru>
Date: 7 Jun 2002 05:37:53 -0700
Message-ID: <1543a3e7.0206070437.3735a6dd@posting.google.com>

You can use dbms_sql package to create sql satement at runtime. It looks like:

CREATE OR REPLACE PROCEDURE insert_into_table(tab_name IN VARCHAR2) AS   c INTEGER;
  rows INTEGER;
BEGIN
  c := dbms_sql.open_cursor;
  dbms_sql.parse(c, ’insert into ‘||tab_name||’ values <your_values>’, dbms_sql.native);   rows := dbms_sql.execute(c);
  dbms_sql.close_cursor(c);
END; Regards,
Michael
Brainbench MVP for Oracle Programming
http://www.brainbench.com

tsachis_at_boi.gov.il (zachi) wrote in message news:<6af31984.0206062226.10454d6c_at_posting.google.com>...
> Hi
> I want to write a procedure that insert into table which its name is pass
> to the procedure as a parameter
> i.e
> procedute temp(tab varchr2) is
> begin
> insert into temp values(etc...)
> ofcourse that the tab name erresent a table which has the appropiate coloums
> please help me
> p.s
> what is IN parameter
Received on Fri Jun 07 2002 - 07:37:53 CDT