stored procedure and truncate [message #36767] |
Wed, 19 December 2001 04:06 |
Thierry
Messages: 9 Registered: January 2000
|
Junior Member |
|
|
this stored procedure is valid, but when i use it,
begin
ic_truncate_table ('ic_insc_presence');
end;
i've got an error
why?
thanks
CREATE OR REPLACE PROCEDURE IC_TRUNCATE_TABLE (v_tab_name in varchar2) is
TexteSQL varchar2(2000);
BEGIN
TexteSql:='EXECUTE IMMEDIATE '||''''||'TRUNCATE TABLE '||v_tab_name||'''';
Execute immediate(TexteSql);
END ;
----------------------------------------------------------------------
|
|
|
|