Re: truncate table in stored pl/sql proc

From: <>
Date: Fri, 28 May 1999 13:17:10 GMT
Message-ID: <7im50k$go8$>


[Quoted] You have to use DBMS_SQL package to issue DDL commands from pl/sql. Also the user should be granted the drop table privilege directly and not thru a role. PL/SQL stored procedures do not recognise roles.

Thanks. Manoja.

In article <>,   Big Bear <> wrote:
> hello,
> could anyone out there tell me if it is possible to include truncate
> table command in a pl/sql stored procedure. i tried it but when i
> compile it gives error "expecting 'table' when expecting......"
> thanks & regards.

Sent via
Share what you know. Learn what you don't. Received on Fri May 28 1999 - 15:17:10 CEST

Original text of this message