Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Using DDL commands in PL/SQL

Using DDL commands in PL/SQL

From: Mikael Schonenberg <micke_at_netg.se>
Date: Tue, 28 Apr 1998 14:15:56 +0200
Message-ID: <Pine.LNX.3.96.980428141316.23404A-100000@valdez.netg.se> 






 Through dbms_sql (in PL/SQL) I manage to use DDL commands, which is very
nice. Problem is I don't manage all of them. Drop Table works fine, but
when I try to Create Table it complaints about insufficient priviliges.
Well, I found that somewhat hard to believe, since the user woning
and running the PL/SQL package is granted the DBA role.



 Any idea?



/Mikael

Received on Tue Apr 28 1998 - 07:15:56 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US