Re: Requirements to create stored procedures, part II

Stefano UNTERNAEHRER (unter_at_mecati.mecasoft.ch) wrote: <snip>
: 1--
 

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

I overcame this error by increasing the value for the share_pool_size parameter of the init.ora file

: 2--
 

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

same as 1.

: 3--
 

: 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

Your rollback segment is too small OR you ran out of space in the rollback segment tablespace. See the manuals for instructions on creating a larger rollback segment and adding files to tablespaces.

 : 4--  

: insert into sys.duc$ (owner, pack, proc, operation, seq, com)
: *
: ERROR at line 1:
: ORA-00001: unique constraint (SYS.I_DUC) violated

Don't know about this one.

: 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

Probably caused by the previous ones but you can tell more by typing SHOW ERRORS after compiling a procedure.

Hope this gets you a bit further.

--
Murray Kaiser                  | Usual gutless disclaimer.. 
Nova Scotia Power              | Opinions are mine and not necessarily
(Murray.Kaiser_at_NSPower.NS.CA)  | shared by my employer