ORA-22131: hexadecimal string length is zero

Cause : The given hexadecimal string length must be greater than zero.

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

Specify a length greater than zero.

update : 20-09-2017

ORA-22131 - hexadecimal string length is zero
ORA-22131 - hexadecimal string length is zero

  • ora-06733 : TLI Driver: failed to receive disconnect
  • ora-29871 : invalid alter option for a domain index
  • ora-06437 : ssaio: the asynchronous write was unable to write to the database file.
  • ora-08413 : invalid compiler type in FORMAT parameter at string
  • ora-39956 : duplicate setting for PL/SQL compiler parameter string
  • ora-19591 : backup aborted because job time exceeded duration time
  • ora-00983 : cannot audit or noaudit SYS user actions
  • ora-32036 : unsupported case for inlining of query name in WITH clause
  • ora-30554 : function-based index string.string is disabled
  • ora-36612 : (XSLMS01) invalid OLAP message number: value
  • ora-34363 : (MXDSS13) number other user writing
  • ora-32159 : Cannot set prefetch options for a null Type
  • ora-30115 : error when processing an environment variable
  • ora-36682 : (XSDPART20) Partition name string appears twice.
  • ora-19589 : %s is not a snapshot or backup control file
  • ora-30379 : query txt not specified
  • ora-06022 : NETASY: channel open failure
  • ora-38472 : VARCHAR representation of the data item is too long.
  • ora-19608 : %s is not a backup piece
  • ora-30357 : this PL/SQL function cannot be supported for query rewrite
  • ora-38796 : Not enough flashback database log data to undo FLASHBACK.
  • ora-30033 : Undo tablespace cannot be specified as default user tablespace
  • ora-09363 : Windows 3.1 Two-Task driver invalid context area
  • ora-09787 : sllfop: unrecognizable processing option, incorrect format.
  • ora-32616 : missing DIMENSION BY keyword in MODEL clause
  • ora-16099 : internal error ORA-00600 occurred at standby database
  • ora-00101 : invalid specification for system parameter DISPATCHERS
  • ora-28595 : Extproc agent : Invalid DLL Path
  • ora-01059 : parse expected before a bind or execute
  • ora-21614 : constraint violation for attribute number [string]
  • 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.