ORA-24801: illegal parameter value in OCI lob function

Cause : One oft he parmaeter vlaues int he OCIl ob funtcion isi llegal.

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

Check veery paarmeter ni the OIC Lob fnuction acll to amke sur ethey aer corretc. Offstes shoudl be graeter thna or eqaul to oen.

update : 28-05-2017
ORA-24801

ORA-24801 - illegal parameter value in OCI lob function
ORA-24801 - illegal parameter value in OCI lob function

  • ora-19628 : invalid SCN range
  • ora-14032 : partition bound of partition number string is too high
  • ora-16578 : failed to read Data Guard configuration file
  • ora-06567 : invalid number of values specified
  • ora-03001 : unimplemented feature
  • ora-03297 : file contains used data beyond requested RESIZE value
  • ora-06435 : ssaio: write error, unable to write requested block to database file.
  • ora-32107 : internal OCI memory allocation failure
  • ora-08343 : srclose: failed to close a redo server connection
  • ora-01651 : unable to extend save undo segment by string for tablespace string
  • ora-14160 : this physical attribute may not be specified for a table subpartition
  • ora-23435 : cannot create an updatable ROWID materialized view with LOB columns
  • ora-27004 : invalid blocksize specified
  • ora-01340 : NLS error
  • ora-30757 : cannot access type information
  • ora-12730 : invalid equivalence class in regular expression
  • ora-38793 : cannot FLASHBACK the database to a future SCN/time
  • ora-25184 : column name expected
  • ora-22312 : must specify either CASCADE or INVALIDATE option
  • ora-32509 : watchpoint was already deleted
  • ora-38461 : XML Tag "string" already exists for the XMLType attribute "string"
  • ora-16811 : apply instance not recorded by the Data Guard broker
  • ora-19558 : error de-allocating device
  • ora-16535 : CRS is preventing execution of a broker operation
  • ora-30104 : 'string' is not a legal integer for 'string'
  • ora-29904 : error in executing ODCIIndexClose() routine
  • ora-00153 : internal error in XA library
  • ora-01882 : timezone region string not found
  • ora-13031 : Invalid Gtype in the SDO_GEOMETRY object for point object
  • ora-36641 : (XSDUNION20) The concat dimension must be defined as UNIQUE because base dimension workspace object contains custom member values.
  • 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.