Oracle-L: 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)

Message Header Follows ------ Received: from disdns1.wa.gov by DOR.WA.GOV (PostalUnion/SMTP(tm) v2.1.8 for Windows NT(tm)) id AA-1996Jan29.102623.1104.26440; Mon, 29 Jan 1996 10:26:27 -0800 Received: by disdns1.wa.gov (5.65/DEC-Ultrix/4.3) id AA06571; Mon, 29 Jan 1996 10:25:24 -0800 Message-Id: <9601291825.AA06571_at_disdns1.wa.gov> Received: from CCVM.SUNYSB.EDU by ccvm.sunysb.edu (IBM VM SMTP V2R3) with BSMTP id 7946; Mon, 29 Jan 96 13:08:13 EST Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV_at_SBCCVM) by CCVM.SUNYSB.EDU (LMail V1.2a/1.8a) with BSMTP id 8384; Mon, 29 Jan 1996 13:08:05 -0500 Date: Mon, 29 Jan 1996 12:14:58 -0500 Reply-To: "ORACLE database mailing list." <ORACLE-L_at_ccvm.sunysb.edu> Sender: "ORACLE database mailing list." <ORACLE-L_at_ccvm.sunysb.edu> From: Mary.M.Spence_at_GPC.COM Subject: Dynamic SQL and rollback segments X-To: "ORACLE-L_at_CCVM.SUNYSB.EDU" </S=ORACLE-L#064#CCVM.SUNYSB .EDU/O=SMTP/P=SOUTHERN/A=ATTMAIL/C=US/@x400gw.scsnet.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_ccvm.sunysb.edu>

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