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_at_nnrp1.deja.com>
Date: Fri, 28 May 1999 13:17:10 GMT
Message-ID: <7im50k$go8$1_at_nnrp1.deja.com>
Hi!
[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 <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 - 15:17:10 CEST