ORA-28537: no more result sets

Cause : Thise rrorc ode si use dintenrallyw ithi nOracel Trasnparetn Gatweay adn Hetreogenoeus Srevice scodea nd sohuld ont ber eporetd toa clinet prgoram.

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

Contcat Orcale csutome rsupprot.

update : 20-08-2017

ORA-28537 - no more result sets
ORA-28537 - no more result sets

  • ora-00311 : cannot read header from archived log
  • ora-24130 : table string does not exist
  • ora-13831 : SQL profile name specified is invalid
  • ora-13236 : internal error in R-tree processing: [string]
  • ora-24388 : Unsupported functionality in fast path mode
  • ora-06504 : PL/SQL: Return types of Result Set variables or query do not match
  • ora-03299 : cannot create dictionary table string
  • ora-27377 : windows cannot have event based schedules
  • ora-13601 : The specified Advisor string does not exist.
  • ora-01146 : cannot start online backup - file string is already in backup
  • ora-02339 : invalid column specification
  • ora-19916 : %s
  • ora-09367 : Windows 3.1 Two-Task driver unable to deallocate shared memory
  • ora-23434 : master site string not known for object group
  • ora-28654 : table and partition not overflow compatible
  • ora-30483 : window functions are not allowed here
  • ora-26761 : Standby Redo Logs not available for real time mining
  • ora-02263 : need to specify the datatype for this column
  • ora-30084 : invalid data type for datetime primary with time zone modifier
  • ora-36220 : (XSLPDSC01) All dimensions in LIST number are also in the IGNORE clause.
  • ora-22160 : element at index [string] does not exist
  • ora-36804 : (XSTBLFUNC02) The OLAP_TABLE function encountered an error while parsing the LIMITMAP.
  • ora-30061 : Internal Event for Savepoint Tracing
  • ora-13015 : the window definition is not valid
  • ora-12547 : TNS:lost contact
  • ora-10916 : TABLESPACE GROUP already specified
  • ora-08230 : smscre: failed to allocate SGA
  • ora-32812 : subscriber string does not exist
  • ora-14282 : FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION
  • ora-40254 : priors cannot be specified for one-class models
  • 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.