Re: DROP TABLE in STORED PROCEDURES

From: James Lorenzen <james_lorenzen_at_allianzlife.com>
Date: Wed, 05 May 1999 13:36:20 GMT
Message-ID: <7gphgk$fe0$1@nnrp1.dejanews.com>

Three questions:

1.  How are the "DROP" statements inserted in the stored procedures?
2.  What is the error that is returned?
3.  Do you know how (via role or direct) you have the permissions?

PL*SQL does not permit ddl statments directly, the ddl statements must be handled via the DBMS_SQL package (for dynamic SQL). Oracle stored procedures do not recognize permissions granted via roles.

HTH
James

In article <7gpdre$bu8$1_at_sharon.cilea.it>, "Diego Peroni" <peroni_at_cefriel.it> wrote:
> I inserted some 'DROP' statements in Oracle8 stored procedures... but when I
> compiled it Oracle returns compilation errors for every DROP statement
> inserted!
>
> I'm SYSDBA and I have the permissions to create or destroy TABLES...
>
> Someone can help me?
>
> Thanks
> Diego Peroni
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed May 05 1999 - 08:36:20 CDT