Re: truncate table in stored pl/sql proc

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 28 May 1999 15:42:29 +0800
Message-ID: <374E48E5.6FF6@yahoo.com>

meranki_at_my-deja.com wrote:
>
> 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.

Or "execute_immediate" in 8i

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Fri May 28 1999 - 02:42:29 CDT