Oracle7 Server Messages
08401-08499: PL/SQL Utility Packages for Procedural Gateway
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 need, just for information. | |
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. | |