Problem with DBMS_SQL
Date: 1998/11/19
Message-ID: <3654572D.2F8DA7F9_at_us.oracle.com>#1/1
Hi everybody, I'm trying to run a Script to populate a table, but I
receive an error message in my function :
And my Package/Function is:
CREATE OR REPLACE PACKAGE Charge_Y2k_Tables
IS
PROCEDURE Insert_Data (own in varchar2, tab in varchar2, col in
varchar2, data in varchar2);
CREATE OR REPLACE PACKAGE BODY Charge_Y2k_Tables
AS
ORA-06512: at "SYS.DBMS_SYS_SQL", line 491
ORA-06512: at "SYS.DBMS_SQL", line 32
ORA-06512: at "SYSTEM.CHARGE_Y2K_TABLES", line 56
ORA-06512: at line 67
I call the Package/Function with:
Charge_Y2k_Tables.Insert_Data(tab.OWNER,tab.TABLE_NAME, col_names,
my_values);
END Charge_Y2k_Tables;
PROCEDURE Insert_Data (own in varchar2, tab in varchar2, col in
varchar2, data in varchar2)
IS
my_cur integer;
rows_processed number;
BEGIN
my_cur := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE(my_cur, 'Insert into ' || own || '.' || tab || ' (' ||
col || ') values(' || data || ');', DBMS_SQL.V7);
END Insert_Data;
END Charge_Y2k_Tables;
What is wrong with this???
Any comment will be appreciate !!!!!
Thanks !!!
Received on Thu Nov 19 1998 - 00:00:00 CET