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-05-2017
ORA-22321

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

  • ora-02229 : invalid SIZE option value
  • ora-13404 : invalid ultCoordinate parameter
  • ora-14122 : only one REVERSE or NOREVERSE clause may be specified
  • ora-02031 : no ROWID for fixed tables or for external-organized tables
  • ora-27089 : unable to release advisory lock
  • ora-01576 : The instance string is not enabled
  • ora-24801 : illegal parameter value in OCI lob function
  • ora-27024 : skgfqsbi: sbtinit2 returned error
  • ora-24414 : Only number sessions could be started.
  • ora-29386 : plan or consumer group string is mandatory and cannot be deleted or modified
  • ora-16812 : log apply service not running on apply instance recorded by the broker
  • ora-24185 : transformation string.string does not exist
  • ora-24300 : bad value for mode
  • ora-31618 : dump file size too small
  • ora-02045 : too many local sessions participating in global transaction
  • ora-29933 : object being disassociated has some user defined statistics stored
  • ora-12236 : TNS:protocol support not loaded
  • ora-02721 : osnseminit: cannot create semaphore set
  • ora-02308 : invalid option string for object type column
  • ora-00962 : too many group-by / order-by expressions
  • ora-30341 : dropped level has references
  • ora-34181 : (MXCHGDCL21) workspace object is not a partitioned VARIABLE.
  • ora-24352 : invalid COBOL display type passed into OCI call
  • ora-00033 : current session has empty migration password
  • ora-36176 : (XSMXAGGR25) Relation workspace object must be a one-dimensional self-relation to be used as a weight for AGGREGATE.
  • ora-29509 : incorrectly formed Java binary class definition
  • ora-14006 : invalid partition name
  • ora-07599 : spwat: $SCHDWK failure
  • ora-02437 : cannot validate (string.string) - primary key violated
  • ora-13413 : null or invalid resampling parameter
  • 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.