Re: truncate table in stored pl/sql proc

From: <meranki_at_my-deja.com>
Date: Fri, 28 May 1999 13:17:10 GMT
Message-ID: <7im50k$go8$1@nnrp1.deja.com>

Hi!

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 <3736EE84.2901613B_at_hotmail.com>, Big Bear <ta_xiong_at_hotmail.com> 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 Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri May 28 1999 - 08:17:10 CDT