Requirements to create stored procedures, part II

From: Stefano UNTERNAEHRER <unter_at_mecati.mecasoft.ch>
Date: 1995/08/30
Message-ID: <DE46J7.5Fs_at_mecati.mecasoft.ch>#1/1


Hi everybody.
To permit me to create stored procedure I've missed do let run the catproc.sql script as sys user. So I've done it, but during the script it occours four errors:

1--

create package body sys.diana is
*

ERROR at line 1:
ORA-04031: unable to allocate 12496 bytes of shared memory ("unknown object","PL/SQL MPCODE","BAMIMA: Bam Buffer")

2--

create or replace package body sys.diutil is
*

ERROR at line 1:
ORA-04031: unable to allocate 34416 bytes of shared memory ("unknown object","PL/SQL MPCODE","BAMIMA: Bam Buffer")

3--

CREATE OR REPLACE PACKAGE BODY dbms_irefresh COMPRESS
*

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1
ORA-01562: failed to extend rollback segment (id = 2)
ORA-01650: unable to extend rollback segment R02 by 32 in tablespace RBS

4--

insert into sys.duc$ (owner, pack, proc, operation, seq, com)
*

ERROR at line 1:
ORA-00001: unique constraint (SYS.I_DUC) violated

---

Are they important errors? What I have to do to solve it?
After this script I've tryed to create my first procedure:

SQL> <at>/users/oracle7/doc/04_StoredProc/t02_stored

Warning: Procedure created with compilation errors.

SQL>

Is this an error due to the previous one or probably an internal
error in the procedure definition?
Hope to read some good news... thank you!
Stefano
                       ____________________________
______________________|    Stefano Unternaehrer    |__________________________
\  Mecasoft SA        |         Oracle DBA         | fax:    +41 93 335 507  /
 \ 6600 Muralto       |     and  PL/SQL, Pro*C     | voice:  +41 93 337 444 /
  \                   |     C, XWindow & Motif     |                       /
  /                   |     Software Developer     | email:                \
 / Switzerland Europe |____________________________|  dba,unter_at_mecasoft.ch \
/________________________)                      (____________________________\
Received on Wed Aug 30 1995 - 00:00:00 CEST

Original text of this message