Re: DBMS_SQL and DBMS_OUTPUT package

From: Dan Clamage <clamage_at_mime.dw.lucent.com>
Date: 1997/10/29
Message-ID: <01bce453$e8968b90$54110b87@clamagent>#1/1

> I am trying to create a table using a PL/SQL procedure who's input
> parameter is the table name. I use the DBMS_SQL.PARSE procedure to do
this.
> I can create the procedure sucessfully however when I try an execute it I
> get the following message:
> ORA-01031: insufficient privileges

You probably have create table privilege granted via a role instead of directly.

> Isn't DBMS_OUTPUT.ENABLE equivalent to running a 'SET SERVEROUPUT ON' ?
No. You must do both. Received on Wed Oct 29 1997 - 00:00:00 CST