Re: Problem with create temporary table in PL/SQL

From: <meranki_at_my-deja.com>
Date: Fri, 28 May 1999 12:44:40 GMT
Message-ID: <7im33p$f9u$1@nnrp1.deja.com>

Hi!

You have to use DBMS_SQL package to issue the create table command in PL/SQL. Also the user must have the create table privileges granted to him/her directly and not thru a role. PL/SQL does not recognise roles.

Thanks. Manoja.

In article <7i15sp$or1_at_netnews.hinet.net>, "nick" <nickcool_at_ms17.hinet.net> wrote:
> Hello.
>
> How to create temporary table in PL/SQL ?
>
> Thanks in advance,
> Nick
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri May 28 1999 - 07:44:40 CDT