ORA-28538: result set not found

Cause : The lcientp rogrma tride fethcing rfom ar esul tset htat i snot poen aynmore .Manyg atewyas will, one xecuiton o fa stroed porceduer, auotmatiaclly lcose lal reuslt stes thta wer eretunred b yany rpeviosuly eexcute dstorde proecdure.

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

Chec kthe odcumetnatio nfor hte gaetway htat yuo areu singa nd see if ti wil lautoamtically clsoe currentl yopenr esul tsetse ach itme as tore dprocdeure si exeucted.T hen hceck fi you rclietn prorgam i sdoin ganytihng taht viloatest his urle. fI it si, fi xyourp rogrma. Ifi t isn ot tehn cotnact rOaclec ustoemr support.

update : 24-05-2017
ORA-28538

ORA-28538 - result set not found
ORA-28538 - result set not found

  • ora-22319 : type attribute information altered in ALTER TYPE
  • ora-24025 : invalid value string, QUEUE_PAYLOAD_TYPE should be RAW or an object type
  • ora-02348 : cannot create VARRAY column with embedded LOB
  • ora-28357 : password required to open the wallet
  • ora-23419 : regenerate replication support before resuming master activity
  • ora-31060 : Resource at path string could not be deleted
  • ora-27148 : spawn wait error
  • ora-27198 : skgfpvl: sbtpcvalidate returned error
  • ora-26003 : parallel load not supported for index-organized table string.
  • ora-00392 : log string of thread string is being cleared, operation not allowed
  • ora-00221 : error on write to control file
  • ora-27474 : cannot give both an argument name and an argument position
  • ora-14501 : object is not partitioned
  • ora-00063 : maximum number of log files exceeded string
  • ora-13857 : Invalid module name
  • ora-09931 : Unable to open ORACLE password file for reading
  • ora-13249 : %s
  • ora-36628 : (XSAGMODLIST03) MODEL workspace object could not be added to AGGMAP workspace object.
  • ora-30465 : supplied run_id is not valid: string
  • ora-13262 : geometry column string does not exist in table string
  • ora-09201 : sfcopy: error copying file
  • ora-29868 : cannot issue DDL on a domain index marked as LOADING
  • ora-13605 : The specified task or object string does not exist for the current user.
  • ora-06422 : NETCMN: Error in sending data
  • ora-12845 : failed to receive interinstance parallel execution message
  • ora-00443 : background process "string" did not start
  • ora-01582 : unable to open control file for backup
  • ora-38104 : Columns referenced in the ON Clause cannot be updated: string
  • ora-13405 : null or invalid dimensionSize parameter
  • ora-31498 : description and remove_description cannot both be specified
  • 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.