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 -> execute DDL from an stored procecure, using native dynamic sql (ORA v8.1.6)

execute DDL from an stored procecure, using native dynamic sql (ORA v8.1.6)

From: Jon <aaa_at_bbb.ccc>
Date: Tue, 20 May 2003 17:39:12 +0200
Message-ID: <badi5q$j9u$1@unbe.sarenet.es> 






Hi,c onnected as a user with DBA role, I am trying to execute a procedure
with some


native dynamic sql statements embebed that tries to do some DDL (...create
table), however,


when trying to run the stored procedure, and altough the user I am connected
with has DBA role,


it returns the following error: ORA-01031: insufficient privileges. Do I
need any other


special privilege for running native dynamic sql and DDL instructions? ...
thanks
Received on Tue May 20 2003 - 10:39:12 CDT












Original text of this message













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