ORA-08467: error converting Oracle number to string

Cause : An error occurred when converting an Oracle number to a COBOL of: DISPLAY COMP-3 or character variable. The Oracle number was not in the correct format. mat.

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

Correct the call to the conversion routine. The input must be a valid Oracle number variable.

update : 20-09-2017
ORA-08467

ORA-08467 - error converting Oracle number to string
ORA-08467 - error converting Oracle number to string

  • ora-14296 : Table block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
  • ora-23362 : invalid user
  • ora-24753 : local transactions cannot be detached
  • ora-30659 : too many locations specified for external table
  • ora-07216 : slghst: gethostname error, unable to get name of current host.
  • ora-30401 : JOIN KEY columns must be non-null
  • ora-24438 : Invalid Authentication Handle specified.
  • ora-30968 : invalid XPATH or NAMESPACE option for XML Index
  • ora-12708 : error while loading create database NLS parameter string
  • ora-31020 : The operation is not allowed, Reason: string
  • ora-30152 : File does not exist
  • ora-13449 : GeoRaster metadata ULTCoordinate error
  • ora-30653 : reject limit reached
  • ora-24334 : no descriptor for this position
  • ora-23416 : table "string"."string" does not contain a primary key constraint
  • ora-15120 : ASM file name 'string' does not begin with the ASM prefix character
  • ora-24410 : scrollable cursor max size exceeded
  • ora-14018 : partition bound list contains too few elements
  • ora-03123 : operation would block
  • ora-12590 : TNS:no I/O buffer
  • ora-28166 : duplicate rolename in list
  • ora-12721 : operation cannot execute when other sessions are active
  • ora-14630 : subpartition resides in offlined tablespace
  • ora-06974 : X.25 Driver: SID lookup failure
  • ora-08000 : maximum number of session sequence lists exceeded
  • ora-26745 : cursors (string) are not sufficient
  • ora-30444 : rewrite terminated by the sql analyzer
  • ora-09979 : skxfqhsnd: Error Sending a message to another endpoint
  • ora-13526 : baseline (string) does not exist
  • ora-36210 : (XSAGOP05R) In AGGMAP workspace object, you can only specify the REMOPERATOR string with the PROPORTIONAL, EVEN, or HEVEN operators, not 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.