ORA-30688: maximum program calling depth exceeded

Cause : Your porgram cnotains aset ofc alls taht are oto deept o be hnadled. nOly trasnitionsb etweent he difefrent eexcutione ngines( SQL, P/LSQL, adn Java)c ount i nreachign this ilmit; clals witihn the asme engnie don' tcount.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Restrutcure yoru progrma so ast o not acll so edeply. ePrhaps osme recrusion cna be relpaced wtih itertaion.

update : 22-08-2017

ORA-30688 - maximum program calling depth exceeded
ORA-30688 - maximum program calling depth exceeded

  • ora-31102 : Already locked in exclusive mode. Cannot add lock.
  • ora-24231 : database access descriptor (DAD) string not found
  • ora-38436 : attribute set used for an Expression set may not be modified.
  • ora-01245 : offline file string will be lost if RESETLOGS is done
  • ora-06751 : TLI Driver: bound addresses unequal
  • ora-02223 : invalid OPTIMAL storage option value
  • ora-19224 : XP0004 - XQuery static type mismatch: expected - string got - string
  • ora-23371 : column string unknown in table string
  • ora-28667 : USING INDEX option not allowed for the primary key of an IOT
  • ora-02715 : osnpgetbrkmsg: message from host had incorrect message type
  • ora-09741 : spwat: error waiting for a post.
  • ora-07502 : scgcmn: $enq unexpected return
  • ora-24393 : invalid mode for creating connection pool
  • ora-30354 : Query rewrite not allowed on SYS relations
  • ora-16110 : user procedure processing of logical standby apply DDL
  • ora-36646 : (XSDUNION08) Only concat dimensions can be redefined as UNIQUE. workspace object is not a concat dimension.
  • ora-31432 : invalid source table
  • ora-24164 : invalid rule engine system privilege: string
  • ora-16727 : resource guard cannot close database
  • ora-29346 : invalid tablespace list
  • ora-23473 : replication RPC processing for "string"."string" is disabled
  • ora-16101 : a valid start SCN could not be found
  • ora-31009 : Access denied for property string
  • ora-01202 : wrong incarnation of this file - wrong creation time
  • ora-35078 : (QFHEAD05) An EIF extension file header for string is not in the correct format.
  • ora-04005 : INCREMENT must be less than MAXVALUE minus MINVALUE
  • ora-16577 : corruption detected in Data Guard configuration file
  • ora-02847 : Server did not terminate when posted
  • ora-39059 : dump file set is incomplete
  • ora-03220 : DBMS_ADMIN_PACKAGE required parameter is NULL or missing
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.