Requirements to create stored procedures, part II
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