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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Dynamic SQL and rollback segments

Re: Dynamic SQL and rollback segments

From: Michael Pham <MichaelP_at_DOR.WA.GOV>
Date: Mon, 29 Jan 1996 12:21:31 -0800
Message-Id: <9601292038.AA01771@alice.jcc.com>


Mary:

   Check if you have EXECUTE privilege before executing the stored procedure.
Are you a DBA? If you are then try to CONNECT INTERNAL and run the stored procedure again.

   Please let me know what you find out.

MichaelP_at_dor.wa.gov



From: ORACLE database mailing list.
To: Multiple recipients of list ORA
Subject: Dynamic SQL and rollback segments Date: Monday, January 29, 1996 10:38AM

How come I can do the following in an anonymous PL/SQL block, but not in a stored procedure:

     cDDL := dbms_sql.open_cursor;
     dbms_sql.parse(cDDL, 'alter rollback segment bigroll online',
dbms_sql.native);
     dbms_sql.close_cursor(cDDL);

With the stored procedure, I get the following errors:

     ORA-01031: insufficient privileges
     ORA-06512: at "SYS.DBMS_SYS_SQL", line 239
     ORA-06512: at "SYS.DBMS_SQL", line 25
     ORA-06512: at "SCSMGR.MYTEST", line 5

TIA, Mary-Mikell (mary.m.spence_at_gpc.com)

Received on Mon Jan 29 1996 - 15:38:31 CST

Original text of this message

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