Oracle8 Error Messages Release 8.0.4 A58312-01 |
Library | Product | Contents | Index

## 08401-08499: PL/SQL Utility Packages for Procedural Gateway Messages

##### ORA-08401: invalid compiler name: name

Cause: An invalid compiler name was passed to a UTL_PG conversion routine.

Action: Correct the compiler name parameter in the PL/SQL code that called the conversion routine.

##### ORA-08412: error encountered in WMSGBSIZ, size for WMSGBLK is not big enough for warning message

Cause: The WMSGBSIZ is the maximum size for warning message block, it is recommended to be 1024 bytes to 8 kbytes.

Action: Defined WMSGBLK of size between 1k to 8k bytes and update the WMSGBSIZ to the size of WMSGBLK.

##### ORA-08413: invalid compiler type in FORMAT parameter at name

Cause: An invalid compiler type was defined in the format control block. The format control block is invalid.

Action: Check to be sure that the format parameter was built by MAKE_RAW_TO_NUMBER_FORMAT or MAKE_NUMBER_TO_RAW_FORMAT and that it was not accidentally overwritten or modified by the PL/SQL procedure.

##### ORA-08414: error encountered in name

Cause: The function <routine> returned an error. Where <routine> may be:
RAW_TO_NUMBER
NUMBER_TO_RAW
RAW_TO_NUMBER_FORMAT
NUMBER_TO_RAW_FORMAT
MAKE_NUMBER_TO_RAW_FORMAT
MAKE_RAW_TO_NUMBER_FORMAT

Action: This message will be preceded by messages providing details about the error. Check those messages to determine what action to take.

##### ORA-08429: raw data has invalid digit in display type data

Cause: The input raw buffer passed to a UTL_PG RAW_TO_NUMBER conversion routine contained invalid data. The picture mask parameter specified a digit, but the corresponding input from the raw data did not contain a valid digit.

Action: Either the input data is incorrect, or the picture mask is incorrect. Correct the appropriate item.

##### ORA-08430: raw data missing leading sign

Cause: The input raw buffer passed to a UTL_PG RAW_TO_NUMBER conversion routine had no leading sign, but the mask options parameter specified a leading sign.

Action: Correct the input raw data or the mask options so that they match.

##### ORA-08431: raw data missing zero as defined in picture

Cause: The picture mask parameter passed to a UTL_PG RAW_TO_NUMBER conversion routine contained a zero, but the corresponding input from the raw data was not a zero.

Action: Either the input data is incorrect, or the picture mask is incorrect. Correct the appropriate item.

##### ORA-08432: raw data has invalid floating point data

Cause: The input raw data passed to a UTL_PG RAW_TO_NUMBER conversion routine contained invalid floating point data.

Action: Correct the input raw data.

##### ORA-08433: invalid picture type in convert raw to number

Cause: The picture mask parameter passed to a UTL_PG RAW_TO_NUMBER conversion routine contained non-numeric characters, but the conversion was to a numeric data type.

Action: Correct the picture mask parameter.

##### ORA-08434: raw data has invalid trailing sign

Cause: The input raw buffer passed to a UTL_PG RAW_TO_NUMBER conversion routine had no trailing sign, but the mask options parameter specified a trailing sign.

Action: Correct the input raw data or the mask options so that they match.

##### ORA-08435: PICTURE MASK missing the leading sign when SIGN IS LEADING specified

Cause: The input MASK passed to a UTL_PG RAW_TO_NUMBER conversion routine had no leading sign, but the mask options parameter specified a leading sign.

Action: Correct the input raw data or the mask options so that they match.

##### ORA-08436: raw data has invalid sign digit

Cause: The input raw buffer passed to a UTL_PG RAW_TO_NUMBER conversion routine had an invalid sign digit in the position where the picture mask specified a sign.

Action: Correct the input raw data or the picture mask so that they match.

##### ORA-08437: invalid picture type in picture mask

Cause: The picture mask parameter passed to a UTL_PG NUMBER_TO_RAW conversion routine contained non-numeric characters, but the conversion was to a numeric data type.

Action: Correct the picture mask parameter.

##### ORA-08440: raw buffer is too short to hold converted data

Cause: The output raw buffer passed to a UTL_PG NUMBER_TO_RAW conversion routine was not large enough to contain the results of the conversion based on the picture mask.

Action: Increase the raw buffer size to the size necessary to hold the entire result of the conversion.

##### ORA-08441: closed parenthesis missing in picture mask

Cause: A closed parenthesis was missing from the picture mask passed to a UTL_PG conversion routine.

Action: Correct the picture mask.

##### ORA-08443: syntax error in BLANK WHEN ZERO clause in mask options

Cause: A syntax error was found in the BLANK WHEN ZERO clause in the mask options parameter passed to a UTL_PG conversion routine. Valid specifications are: BLANK ZERO, BLANK ZEROS, BLANK ZEROES, BLANK WHEN ZERO, BLANK WHEN ZEROS, and BLANK WHEN ZEROES.

Action: Correct the mask options parameter.

##### ORA-08444: syntax error in JUSTIFIED clause in mask options

Cause: A syntax error was found in the JUSTIFIED clause in the mask options parameter passed to a UTL_PG conversion routine. Valid specifications are: JUST, JUST RIGHT, JUSTIFIED, and JUSTIFIED RIGHT.

Action: Correct the mask options parameter.

##### ORA-08445: syntax error in SIGN clause in mask options

Cause: A syntax error was found in the SIGN clause in the mask options parameter passed to a UTL_PG conversion routine. Valid specifications are: SIGN, LEADING SIGN, LEADING SEPARATE SIGN, LEADING SEPARATE CHARACTER SIGN, TRAILING SIGN, TRAILING SEPARATE SIGN, TRAILING SEPARATE CHARACTER SIGN IS LEADING, SIGN IS LEADING, SEPARATE SIGN IS LEADING, SEPARATE CHARACTER SIGN IS TRAILING, SIGN IS TRAILING, SEPARATE SIGN IS TRAILING, and SEPARATE CHARACTER.

Action: Correct the mask options parameter.

##### ORA-08446: syntax error in SYNCHRONIZED clause in mask options

Cause: A syntax error was found in the SYNCHRONIZED clause in the mask options parameter passed to a UTL_PG conversion routine. Valid specifications are: SYNC, SYNC LEFT, SYNC RIGHT, SYNCHRONIZED, SYNCHRONIZED LEFT, and SYNCHRONIZED RIGHT.

Action: Correct the mask options parameter.

##### ORA-08447: syntax error in USAGE clause in mask options

Cause: A syntax error was found in the USAGE clause in the mask options parameter passed to a UTL_PG conversion routine. Valid specifications are: USAGE, DISPLAY USAGE, COMP USAGE, COMP-3 USAGE, COMP-4 USAGE, COMPUTATIONAL USAGE, COMPUTATIONAL-3 USAGE, COMPUTATIONAL-4 USAGE IS, DISPLAY USAGE IS, COMP USAGE IS, COMP-3 USAGE IS, COMP-4 USAGE IS, COMPUTATIONAL USAGE IS, COMPUTATIONAL-3 USAGE IS, and COMPUTATIONAL-4.

Action: Correct the mask options parameter.

##### ORA-08448: syntax error in DECIMAL-POINT environment clause

Cause: A syntax error was found in the DECIMAL-POINT environment clause parameter passed to a UTL_PG conversion routine. Valid specifications are: DECIMAL-POINT IS COMMA.

Action: Correct the environment clause parameter.

##### ORA-08449: invalid numeric symbol found in picture mask

Cause: An invalid numeric symbol was found in the picture mask parameter passed to a UTL_PG conversion routine.

Action: Correct the picture mask parameter.

##### ORA-08450: invalid specification of CR in picture mask

Cause: The CR suffix was incorrectly specified in the picture mask parameter passed to a UTL_PG conversion routine. The CR suffix can only appear at the end of a picture mask.

Action: Correct the picture mask parameter.

##### ORA-08451: invalid specification of DB in picture mask

Cause: The DB suffix was incorrectly specified in the picture mask parameter passed to a UTL_PG conversion routine. The DB suffix can only appear at the end of a picture mask.

Action: Correct the picture mask parameter.

##### ORA-08452: specification of E in picture mask is unsupported

Cause: The floating point exponent symbol "E" was specified in the picture mask parameter passed to a UTL_PG conversion routine. The floating point data type is currently not supported by the UTL_PG conversion routines.

Action: Correct the picture mask parameter, and the data, if necessary.

##### ORA-08453: more than one V symbol specified in picture mask

Cause: The picture mask passed to a UTL_PG conversion routine contained more than one decimal point indicator "V". Only one decimal point indicator is allowed in the picture mask.

Action: Correct the picture mask parameter.

##### ORA-08454: more than one S symbol specified in picture mask

Cause: The picture mask passed to a UTL_PG conversion routine contained more than one operational sign indicator "S". Only one operational sign indicator is allowed in the picture mask.

Action: Correct the picture mask parameter.

##### ORA-08455: syntax error in CURRENCY SIGN environment clause

Cause: A syntax error was found in the CURRENCY SIGN environment clause parameter passed to a UTL_PG conversion routine. Valid specifications are: CURRENCY SIGN IS x, where x is a valid currency sign.

Action: Correct the environment clause parameter.

##### ORA-08456: no sign in picture mask but SIGN clause in mask options

Cause: The picture mask parameter passed to a UTL_PG conversion routine contained no sign symbol, "S", "+", or "-", but the mask options parameter contained a SIGN clause. A sign symbol is required in the picture mask parameter when the mask options parameter contains a SIGN clause.

Action: Correct the picture mask parameter or the mask options parameter.

##### ORA-08457: syntax error in SEPARATE CHARACTER option of SIGN clause

Cause: A syntax error was found in the SEPARATE CHARACTER option of the SIGN clause in the mask options parameter passed to a UTL_PG conversion routine. Valid specifications are: SEPARATE and SEPARATE CHARACTER.

Action: Correct the mask options parameter.

##### ORA-08458: invalid format parameter

Cause: The format parameter passed to a UTL_PG conversion routine was invalid. The format parameter should have been built by a prior call to either MAKE_RAW_TO_NUMBER_FORMAT or MAKE_NUMBER_TO_RAW_FORMAT.

Action: Check to be sure that the format parameter was built by MAKE_RAW_TO_NUMBER_FORMAT or MAKE_NUMBER_TO_RAW_FORMAT and that it was not accidentally overwritten or modified by the PL/SQL procedure.

##### ORA-08459: invalid format parameter length

Cause: The format parameter passed to a UTL_PG conversion routine was not the correct length. Format parameters must be 2048 bytes in length.

Action: Check to be sure that the format parameter was built by MAKE_RAW_TO_NUMBER_FORMAT or MAKE_NUMBER_TO_RAW_FORMAT and that it was not accidentally overwritten or modified by the PL/SQL procedure.

##### ORA-08460: invalid environment clause in environment parameter

Cause: The environment parameter passed to a UTL_PG conversion routine contained an unsupported or invalid environment clause. Only the CURRENCY SIGN and the DECIMAL-POINT IS COMMA environment clauses are supported.

Action: Correct the environment parameter.

##### ORA-08462: raw buffer contains invalid decimal data

Cause: The input raw buffer passed to a UTL_PG RAW_TO_NUMBER conversion routine contains invalid decimal data.

Action: Correct the input data.

##### ORA-08463: overflow converting decimal number to Oracle number

Cause: The output variable passed to a UTL_PG RAW_TO_NUMBER was not large enough to hold the Oracle number resulting from the input decimal number.

Action: Be sure that the input decimal number is valid, and be sure that the output variable is large enough to hold the Oracle number value.

##### ORA-08464: input raw decimal data contains more than 42 digits

Cause: The input raw buffer passed to a UTL_PG RAW_TO_NUMBER conversion routine contained more than 42 digits. This exceeds the maximum size of an Oracle number.

Action: Correct the raw input buffer.

##### ORA-08465: input mask contains more than 32 characters

Cause: The input mask passed to UTL_PG numeric conversion routine contained more the 32 characters.

Action: Correct the mask input buffer.

##### ORA-08466: raw buffer length num is too short for name

Cause: The input raw buffer passed to a UTL_PG RAW_TO_NUMBER conversion routine was less than num bytes long, but the picture mask parameter specified that num bytes of input data were to be converted.

Action: Either the input data is incorrect, or the picture mask is incorrect. Correct the appropriate item.

##### ORA-08467: error converting Oracle number to num

Cause: An error occurred when converting an Oracle number to a COBOL <type> of:
DISPLAY
COMP-3
or character variable.

  The Oracle number was not in the correct format.

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

##### ORA-08468: mask option name is not supported

Cause: The mask option <clause> was passed to a UTL_PG conversion routine, but is not supported by UTL_PG. The <clause> can be:
USAGE IS POINTER
USAGE IS INDEX
USAGE IS COMP-1
USAGE IS COMP-2
POINTER

Action: Remove the <clause> from the mask options parameter in the PL/SQL call to UTL_PG.

##### ORA-08498: Warning: picture mask name overrides picture mask option USAGE IS name to USAGE IS DISPLAY

Cause: Picture mask option is overridden by Picture mask.

Action: No action required. This is an informational message.

##### ORA-08499: Warning: picture mask options name ignored by UTL_PG

Cause: Picture mask options such as OCCUR, SYNC and others are not processed by the UTL_PG numeric conversion routines.

Action: This is an informational message only. The message may be eliminated by removing the unnecessary picture mask options from the parameter list passed to the UTL_PG routine.

Prev | Top | Next
| Copyright © 1997 Oracle Corporation. All Rights Reserved. |
Library | Product | Contents | Index