OraFAQ Forum: Server Administration » Truncate Table using a Procedure

Home » RDBMS Server » Server Administration » Truncate Table using a Procedure

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

Truncate Table using a Procedure [message #371231]

Wed, 20 September 2000 16:19

Val Herrera
Messages: 1
Registered: September 2000

Junior Member

I want to truncate a table using a procedure, is that possible? What about using dynamic SQL?

Report message to a moderator

Re: Truncate Table using a Procedure [message #371232 is a reply to message #371231]

Thu, 21 September 2000 05:26

Gs
Messages: 8
Registered: September 2000

Junior Member

Use DBMS_SQL, example as following ...

CREATE OR REPLACE PROCEDURE TRUNC_TABLE
(V_TABLE VARCHAR2)
IS
CURSORID NUMBER;
BEGIN
CURSORID := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE(CURSORID, 'TRUNCATE TABLE '||
V_TABLE, DBMS_SQL.NATIVE);
DBMS_SQL.CLOSE_CURSOR(CURSORID);
END;

Hope the above helps.

Report message to a moderator

Re: Truncate Table using a Procedure [message #371234 is a reply to message #371232]

Thu, 21 September 2000 08:18

Rekah
Messages: 1
Registered: September 2000

Junior Member

If you are using Oracle 8i you can try following in your procedure.

EXECUTE IMMEDIATE 'TRUNCATE TABLE table_name';

Report message to a moderator

Previous Topic:	Help On CREATE TYPE OBJECTS.......
Next Topic:	Rollback Segment

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 02:05:31 CST 2025