Re: how to exec "truncate table " in procedures

In article <8segle$qi$1_at_nnrp1.deja.com>,   qiangye_at_my-deja.com wrote:
> Dear professionals,
>
> Here I encounter a problem to execute "truncate table TTT" in the
 stored
> procedures. It seems that "table" is the reserved key word for some
> special use in the stored procedures, compared with in PL/SQL.
>
> So, anybody could let me know how to do that? Appreaications in advanc
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

This is a more generic issue. DDL (Data Definition Language) statements are not allowed in PL/SQL (and stored procedures are part of PL/SQL) You'll need to use dbms_sql (7.3 and 8.0) or execute immediate (8i and above).

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.