i getting error while creating procedure , package. please 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) begin insert customer_tbl values(cid,cname,con,a_no,bal,ttype); end; error-
error report - ora-00604: error occurred @ recursive sql level 1 ora-01653: unable extend table sys.plscope_action$ 128 in tablespace sysaux 00604. 00000 - "error occurred @ recursive sql level %s" *cause: error occurred while processing recursive sql statement (a statement applying internal dictionary tables). *action: if situation described in next error on stack can corrected, so; otherwise contact oracle support.
if you're experiencing error in sql developer, try change, in database> pl/sql compiler, option plscope none. plscope_settings controls compile time collection, cross reference, , storage of pl/sql source code identifier data.
- none: disables collection of identifier data.
- all: enables collection of source code identifier data. default in sqldeveloper.
sqldeveloper default plscope all, , maybe causing error.
