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 : 23-04-2017
ORA-28552

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

  • ora-30753 : column or table string is substitutable
  • ora-01425 : escape character must be character string of length 1
  • ora-07570 : szrfc: $IDTOASC failure
  • ora-29806 : specified binding does not exist
  • ora-31217 : DBMS_LDAP: PL/SQL - Invalid LDAP newparent.
  • ora-28518 : data dictionary translation has illegal translation type
  • ora-10387 : parallel query server interrupt (normal)
  • ora-31670 : Username argument must be specified and non-null.
  • ora-31422 : owner schema string does not exist
  • ora-24091 : Destination queue string is the same as the source queue
  • ora-31637 : cannot create job string for user string
  • ora-32407 : cannot exclude new values when materialized view log includes new values
  • ora-32834 : Messaging Gateway agent user has not been set
  • ora-02254 : DEFAULT not allowed here
  • ora-15052 : ASM file name 'string' is not in diskgroup "string"
  • ora-14094 : invalid ALTER TABLE EXCHANGE PARTITION option
  • ora-38458 : invalid operation "string" for XPATH_FILTER_PARAMETERS
  • ora-39004 : invalid state
  • ora-19924 : there are no row with id string
  • ora-13271 : error allocating memory for geometry object
  • ora-08432 : raw data has invalid floating point data
  • ora-22162 : element at index [string] has been previously deleted
  • ora-24051 : cannot propagate object type payloads that have a REF attribute
  • ora-01347 : Supplemental log data no longer found
  • ora-16047 : DGID mismatch between destination setting and standby
  • ora-27191 : sbtinfo2 returned error
  • ora-15009 : ASM disk "string" does not exist
  • ora-02224 : EXECUTE privilege not allowed for tables
  • ora-16703 : cannot set property while the database is enabled
  • ora-08103 : object no longer exists
  • 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.