Getting Error-ORA-00604, while creating new procedure in oracle sql developer

Question

I am getting error while creating procedure and package. Please anyone help me.

My procedure code-

CREATE OR REPLACE PROCEDURE IPROC(CID IN NUMBER, CNAME IN VARCHAR2, CON IN NUMBER, A_NO IN NUMBER, BAL IN NUMBER, TTYPE VARCHAR2)
AS
BEGIN 
INSERT INTO CUSTOMER_TBL VALUES(CID,CNAME,CON,A_NO,BAL,TTYPE);
END;

Error-

Error report -
ORA-00604: error occurred at recursive SQL level 1

ORA-01653: unable to extend table SYS.PLSCOPE_ACTION$ by 128 in tablespace SYSAUX

00604. 00000 -  "error occurred at recursive SQL level %s"
*Cause:    An error occurred while processing a recursive SQL statement
           (a statement applying to internal dictionary tables).
*Action:   If the situation described in the next error on the stack
           can be corrected, do so; otherwise contact Oracle Support.

Hiro_Hamada · Accepted Answer · 2019-11-27 12:17:44Z

5

If you're experiencing this error only in Sql Developer, try to change, Tools > Preferences > Database > PL/SQL Compiler, the option PLSCope to None. PLSCOPE_SETTINGS controls the compile time collection, cross reference, and storage of PL/SQL source code identifier data.

NONE: Disables collection of identifier data.
ALL: Enables the collection of all source code identifier data. This is the default in SqlDeveloper.

SqlDeveloper default for PLScope is All, and maybe is causing this error.

edited Nov 27, 2019 at 12:17

Hiro_Hamada

1693 silver badges12 bronze badges

answered Jul 2, 2015 at 9:28

Aitor

3,4692 gold badges31 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-04-13 12:42:39Z

0

You have no space left in tablespace SYSAUX Either you also have no space left or your HDD or max limits of SYSAUX are reached. Also look at script mentioned in https://dba.stackexchange.com/questions/33645/sysaux-tablespace-is-98, maybe it will help you.

edited Apr 13, 2017 at 12:42

CommunityBot

11 silver badge

answered Apr 28, 2015 at 5:47

Janis Baiza

9616 silver badges15 bronze badges

Comments

anudeepks · Accepted Answer · 2015-04-28 10:09:21Z

0

If you have acces to the dba_data_files table , This query will show you how much space you have and how much you have utilized. If it is full add another file to the tablespace or ask dba to add another file to it.

SQL> select file_name, sum(bytes)/1024/1024/1024 "current_gb",sum(maxbytes)/1024/1024/1024 "total_gb" from dba_data_files where tablespace_name='SYSAUX' group by file_name;

FILE_NAME                                                    current_gb   total_gb
------------------------------------------------------------ ---------- ----------
C:\AKS\AKDB\ORADATA\RESEARCH\SYSAUX01.DBF                       .546875 31.9999847

To add datafile

Alter tablespace SYSAUX ADD DATAFILE 'C:\AKS\AKDB\ORADATA\RESEARCH\SYSAUX02.DBF' size 100m autoextend of maxsize 2g;

edited Apr 28, 2015 at 10:09

answered Apr 28, 2015 at 6:46

anudeepks

1,1321 gold badge14 silver badges26 bronze badges

2 Comments

Rahul Parit Over a year ago

query is returning only file name. why it is not returning other values?

anudeepks Over a year ago

could you pls post the query and output, which is the oracle version you are using

Collectives™ on Stack Overflow

Getting Error-ORA-00604, while creating new procedure in oracle sql developer

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related