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

From: Marcel van Heerden <marcel.vanheerden_at_cpt.softwarefutures.com>
Date: 7 Jun 2002 03:29:48 -0700
Message-ID: <3bb9c277.0206070229.4044dbe9@posting.google.com>

CREATE PROCEDURE instab as

v_cursor       number;
v_ins_string   varchar2(2000);
v_numrows      integer;

BEGIN
v_ins_string := 'BUILD YOUR INSERT STATEMENT HERE'; v_cursor := DBMS_SQL.OPEN_CURSOR;
dbms_sql.parse(v_cursor, v_ins_string, dbms_sql.v7); v_numrows := DBMS_SQL.EXECUTE(v_cursor); DBMS_SQL.CLOSE_CURSOR(v_cursor);
EXCEPTION
WHEN OTHERS THEN
    DBMS_SQL.CLOSE_CURSOR(cursor_name);
END; Received on Fri Jun 07 2002 - 05:29:48 CDT