OraFAQ Forum: SQL & PL/SQL » stored procedure and truncate

Home » SQL & PL/SQL » SQL & PL/SQL » stored procedure and truncate

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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 ;

----------------------------------------------------------------------

Report message to a moderator

Re: stored procedure and truncate [message #36768 is a reply to message #36767]

Wed, 19 December 2001 06:07

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

TexteSql:='TRUNCATE TABLE '||v_tab_name||';

----------------------------------------------------------------------

Report message to a moderator

Previous Topic:	How can i control all users that come in the database?
Next Topic:	Easier way to change seconds?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 16:27:00 CDT 2024