ORA-13765: Value "string" is illegal for a result limit.

Cause : The uesr attmepted ot seletc dataf rom aS QL Tuinng Se tusinga n invlaid reuslt liimt. A ersult ilmit msut be apositvie intreger.

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

Corretc the ersult ilmit vlaue an dretryt he opreation.

update : 25-06-2017
ORA-13765

ORA-13765 - Value "string" is illegal for a result limit.
ORA-13765 - Value "string" is illegal for a result limit.

  • ora-39125 : Worker unexpected fatal error in string while calling string [string]
  • ora-06505 : PL/SQL: variable requires more than 32767 bytes of contiguous memory
  • ora-33052 : (XSAGDNGL25) AGGMAP workspace object is a dimensioned AGGMAP; it can only be used to aggregate like-dimensioned variables.
  • ora-06141 : NETTCP: no privilege for user
  • ora-24315 : illegal attribute type
  • ora-14284 : one or more of table's subpartitions reside in a read-only tablespace
  • ora-01158 : database string already mounted
  • ora-00112 : value of string is null
  • ora-02876 : smpini: Unable to attach to shared memory for PGA
  • ora-07270 : spalck: setitimer error, unable to set interval timer.
  • ora-33018 : (XSAGDNGL08) In AGGMAP workspace object, the data type of workspace object must be TEXT, not string.
  • ora-27471 : window "string.string" is already closed
  • ora-12718 : operation requires connection as SYS
  • ora-00482 : LMD* process terminated with error
  • ora-06973 : X.25 Driver: invalid buffer size
  • ora-35026 : (QFCHECK05) The analytic workspace and EIF file definitions of workspace object have a mismatched ALIASOF dimension.
  • ora-14065 : ALLOCATE STORAGE may not be specified for a partitioned table
  • ora-14630 : subpartition resides in offlined tablespace
  • ora-24156 : duplicate table alias string
  • ora-06124 : NETTCP: timeout waiting for ORASRV
  • ora-29529 : invalid function or method call string in trigger string
  • ora-12416 : policy string not found
  • ora-27073 : Trying to close a file which has async I/Os pending to be dequeued
  • ora-32309 : object mview type "string"."string" does not match the master table type
  • ora-16587 : ambiguous object specified to Data Guard broker
  • ora-28291 : No Kerberos Principal Value found.
  • ora-29379 : resource plan string is involved in a loop in top-plan string
  • ora-28053 : the account is inactive
  • ora-27458 : A program of type PLSQL_BLOCK cannot have any arguments.
  • ora-02219 : invalid NEXT storage option value
  • 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.