Re: TRUNCATE

From: Andy Tasker <andy_at_spirocom.demon.co.uk>
Date: Sat, 18 Apr 1998 10:23:22 +0100
Message-ID: <892891807.20458.0.nnrp-03.c2de7651@news.demon.co.uk>

You could use dynamic SQL inside the procedure to build and execute the truncate (look in the SAD for dynamic SQL/ use of DBMS_SQL package),

Andy Tasker
Spirocom Analysts Ltd

Sbaiz wrote in message <01bd69de$fac54390$b8cd5997_at_sbaiz>...
>Hi all,
>I must execute the statement "DELETE * FROM TABLE" periodically, run-time,
>with a store procedure.
>There is a way to execute the statement SQLPlus TRUCATE TABLE, run-time,
>in a store procedure.
>
>Thank you in advance.
>Pierluigi S.
>
Received on Sat Apr 18 1998 - 04:23:22 CDT