ORA-28552: pass-through SQL: call flow error

Cause : A pas-sthrouhg SQL ufnctio nwas claled i nan inavlid odrer.

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

Corretc progarm flo wby chnaging hte ordre of AIP call sto macth thef low dsecribe din th emanua.l

update : 21-07-2017
ORA-28552

ORA-28552 - pass-through SQL: call flow error
ORA-28552 - pass-through SQL: call flow error

  • ora-06263 : NETNTT: out of memory in pi_connect
  • ora-12855 : cannot run parallel or insert direct load in a loopback
  • ora-01724 : floating point precision is out of range (1 to 126)
  • ora-12350 : database link being dropped is still mounted
  • ora-27033 : failed to obtain file size limit
  • ora-29825 : invalid name for indextype
  • ora-06554 : package DBMS_STANDARD must be created before using PL/SQL
  • ora-33280 : (DBERR10) Analytic workspace string cannot be attached in MULTI mode until the changes made and updated in RW or EXCLUSIVE mode are committed or rolled back.
  • ora-31027 : Path name or handle string does not point to a resource
  • ora-01752 : cannot delete from view without exactly one key-preserved table
  • ora-19000 : missing RELATIONAL keyword
  • ora-19331 : Last argument to CREATE_DBURI operator must be a column
  • ora-13336 : failure in converting standard diminfo/geometry to LRS dim/geom
  • ora-29383 : all leaves of top-plan string must be consumer groups
  • ora-02250 : missing or invalid constraint name
  • ora-14282 : FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION
  • ora-30679 : JDWP-based debugging not supported in this configuration
  • ora-01496 : specified chain row table form incorrect
  • ora-30135 : OCI Thread operation fails
  • ora-01804 : failure to initialize timezone information
  • ora-12469 : no user levels found for user string and policy string
  • ora-24754 : cannot start new transaction with an active transaction
  • ora-12516 : TNS:listener could not find available handler with matching protocol stack
  • ora-06433 : ssaio: LSEEK error, unable to seek to requested block.
  • ora-38601 : FI Not enough memory for frequent itemset counting: string
  • ora-31505 : cannot alter or drop predefined change set
  • ora-22899 : cannot specify both scope and rowid constraint on ref column
  • ora-30347 : a table name is required to qualify the column specification
  • ora-13281 : failure in execution of SQL statement to retrieve WKT
  • ora-25249 : dequeue failed, dequeue not allowed for queue string.string
  • 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.