ORA-22321: method does not return any result

Cause : OICTpyeeRslut)( awsc alle do nam ehto dtahtd ose ontr eutr nayn erslut.s

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

Cehc ktahty o uaer apsisn gi nteh ocrerc tmtehdo edsrcitpo,r ro hta tyuorm ehto dceraito nwsa odn ecrorcetyl.

update : 23-06-2017
ORA-22321

ORA-22321 - method does not return any result
ORA-22321 - method does not return any result

  • ora-22921 : length of input buffer is smaller than amount requested
  • ora-23480 : Column string is not a top-level column of "string"."string".
  • ora-07409 : slpdtb: invalid packed decimal nibble.
  • ora-06252 : NETNTT: cannot open address file
  • ora-23448 : duplicate user parameter value
  • ora-19863 : device block size string is larger than max allowed: string
  • ora-13138 : could not determine name of object string
  • ora-31624 : A job cannot be modified after it has started.
  • ora-27412 : repeat interval or calendar contains invalid identifier: string
  • ora-26063 : Can not flashback to specified SCN value - Wrap: string Base: string.
  • ora-39772 : column array reset disallowed after OCI_CONTINUE or OCI_NEED_DATA
  • ora-22833 : Must cast a transient type to a persistent type
  • ora-40209 : setting % is invalid for % function
  • ora-38795 : warning: FLASHBACK succeeded but OPEN RESETLOGS would get error below
  • ora-30180 : argument index is too large
  • ora-01271 : Unable to create new file name for file string
  • ora-02281 : duplicate or conflicting CACHE/NOCACHE specifications
  • ora-35017 : (QFCHECK06) The Analytic Workspace and EIF file definitions of workspace object have different partitioning methods.
  • ora-36180 : (XSAGGR08) AGGREGATE cannot function because there is a permission clause associated with variable workspace object.
  • ora-06438 : ssaio: the asynchronous read was unable to read from the database file.
  • ora-00301 : error in adding log file 'string' - file cannot be created
  • ora-07842 : sllfcl: SYS$CLOSE failure
  • ora-14129 : INCLUDING INDEXES must be specified as tables have enabled UNIQUE constraints
  • ora-38468 : column "string" is not identified as a column storing expressions.
  • ora-12827 : insufficient parallel query slaves available
  • ora-31217 : DBMS_LDAP: PL/SQL - Invalid LDAP newparent.
  • ora-38505 : invalid default value for the attribute
  • ora-25197 : an overflow segment already exists for the indexed-organized table
  • ora-15201 : disk string contains a valid RDBMS file
  • ora-39094 : Parallel execution not supported in this database edition.
  • 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.