{"id":2172,"date":"2016-09-03T17:53:48","date_gmt":"2016-09-03T14:53:48","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=2172"},"modified":"2016-12-26T17:55:06","modified_gmt":"2016-12-26T14:55:06","slug":"oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-08400-to-ora-08600","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-08400-to-ora-08600\/","title":{"rendered":"Oracle 12c R2 Error Codes and Solution Suggestions from ORA-08400 to ORA-08600"},"content":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-08400 to ORA-08600<\/strong><\/p>\n

\n
ORA-08401: invalid compiler name:\u00a0string<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid compiler name\u00a0compname<\/i>\u00a0was passed to a UTL_PG conversion routine.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the compiler name parameter in the PL\/SQL code that called the conversion routine.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08402: error executing PL\/SQL code coverage<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred during execution of a PL\/SQL code coverage procedure.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the error stack for more details.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08412: error encountered in WMSGBSIZ, size for WMSGBLK is not big enough for warning message<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The WMSGBSIZ is the maximun size for warning message block, it is recommanded to be 1024 bytes to 8 kbytes.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Defined WMSGBLK of size between 1k to 8k bytes and update the WMSGBSIZ to the sizeof(WMSGBLK).<\/span><\/span><\/p>\n

\n
<\/a> ORA-08413: invalid compiler type in FORMAT parameter at\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid compiler type is defined in format control block. The format control block is invalid.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check 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.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08414: error encountered in\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The function\u00a0routine<\/i>\u00a0returned an error. Where\u00a0routine<\/i>\u00a0may be: RAW_TO_NUMER NUMBER_TO_RAW RAW_TO_NUMBER_FORMAT NUMBER_TO_RAW_FORMAT MAKE_NUMBER_TO_RAW_FORMAT MAKE_RAW_TO_NUMBER_FORMAT<\/span><\/span><\/p>\n

Action:<\/b>\u00a0This message will be preceded by messages providing details about the error. Check those messages to determine what action to take.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08429: raw data has invalid digit in display type data<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Either the input data is incorrect, or the picture mask is incorrect. Correct the appropriate item.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08430: raw data missing leading sign<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the input raw data or the mask options so that they match.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08431: raw data missing zero as defined in picture<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Either the input data is incorrect, or the picture mask is incorrect. Correct the appropriate item.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08432: raw data has invalid floating point data<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The input raw data passed to a UTL_PG RAW_TO_NUMBER conversion routine contained invalid floating point data.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the input raw data.<\/span><\/span>
\n<\/p>\n

\n
<\/a> ORA-08433: invalid picture type in convert raw to number<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the picture mask parameter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08434: raw data has invalid trailing sign<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the input raw data or the mask options so that they match.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08435: PICTURE MASK missing the leading sign when SIGN IS LEADING specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the input raw data or the mask options so that they match.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08436: raw data has invalid sign digit<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the input raw data or the picture mask so that they match.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08437: invalid picture type in picture mask<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the picture mask parameter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08440: raw buffer is too short to hold converted data<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Increase the raw buffer size to the size necessary to hold the entire result of the conversion.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08441: closed parenthesis missing in picture mask<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A closed parenthesis was missing from the picture mask passed to a UTL_PG conversion routine.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the picture mask.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08443: syntax error in BLANK WHEN ZERO clause in mask options<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A 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 BLANK WHEN ZEROES<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the mask options parameter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08444: syntax error in JUSTIFIED clause in mask options<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A 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 JUSTIFIED RIGHT<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the mask options parameter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08445: syntax error in SIGN clause in mask options<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A 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 SEPARATE CHARACTER<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the mask options parameter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08446: syntax error in SYNCHRONIZED clause in mask options<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A 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 SYNCHRONIZED RIGHT<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the mask options parameter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08447: syntax error in USAGE clause in mask options<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A 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 COMPUTATIONAL-4<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the mask options parameter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08448: syntax error in DECIMAL-POINT environment clause<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A 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<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the environment clause parameter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08449: invalid numeric symbol found in picture mask<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid numeric symbol was found in the picture mask parameter passed to a UTL_PG conversion routine.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the picture mask parameter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08450: invalid specification of CR in picture mask<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the picture mask parameter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08451: invalid specification of DB in picture mask<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the picture mask parameter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08452: specification of E in picture mask is unsupported<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the picture mask parameter, and the data, if necessary.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08453: more than one V symbol specified in picture mask<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the picture mask parameter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08454: more than one S symbol specified in picture mask<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the picture mask parameter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08455: syntax error in CURRENCY SIGN environment clause<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A 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<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the environment clause parameter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08456: no sign in picture mask but SIGN clause in mask options<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the picture mask parameter or the mask options parameter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08457: syntax error in SEPARATE CHARACTER option of SIGN clause<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A 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 SEPARATE CHARACTER<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the mask options parameter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08458: invalid format parameter<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check 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.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08459: invalid format parameter length<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The format parameter passed to a UTL_PG conversion routine was not the correct length. Format parameters must be 2048 bytes in length.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check 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.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08460: invalid environment clause in environment parameter<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the environment parameter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08462: raw buffer contains invalid decimal data<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The input raw buffer passed to a UTL_PG RAW_TO_NUMBER conversion routine contains invalid decimal data.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the input data.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08463: overflow converting decimal number to Oracle number<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Be sure that the input decimal number is valid, and besure that the output variable is large enough to hold the Oracle number value.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08464: input raw decimal data contains more than 42 digits<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The 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.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the raw input buffer.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08465: input mask contains more than 32 characters<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The input mask passed to UTL_PG numeric conversion routine contained more the 32 characters.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the mask input buffer.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08466: raw buffer length\u00a0string<\/i>\u00a0is too short for\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The input raw buffer passed to a UTL_PG RAW_TO_NUMBER conversion routine was less than %s bytes long, but the picture mask parameter specified that %s bytes of input data were to be converted.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Either the input data is incorrect, or the picture mask is incorrect. Correct the appropriate item.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08467: error converting Oracle number to\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred when converting an Oracle number to a COBOL\u00a0type<\/i>\u00a0of: DISPLAY COMP-3 or character variable. The Oracle number was not in the correct format.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the call to the conversion routine. The input must be a valid Oracle number variable.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08468: mask option\u00a0string<\/i>\u00a0is not supported<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The mask option\u00a0clause<\/i>\u00a0was passed to a UTL_PG conversion routine, but is not supported by UTL_PG. The\u00a0clause<\/i>\u00a0can be: USAGE IS POINTER USAGE IS INDEX USAGE IS COMP-1 USAGE IS COMP-2 POINTER<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the\u00a0clause<\/i>\u00a0from the mask options parameter in the PL\/SQL call to UTL_PG.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08469: must use the SIGN IS SEPARATE clause in mask options<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A signed numeric entry with DISPLAY usage was converted using a non-defaulted character set and its PICTURE character-string contains an S. In these circumstances, a SIGN IS SEPARATE clause must be specified in the mask options.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Either specify a valid SIGN IS SEPARATE clause in the mask options, use the defaulted character set, or don’t specify an S in the PICTURE character-string.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08498: Warning: picture mask ‘string<\/i>‘ overrides picture mask option ‘USAGE IS\u00a0string<\/i>‘ to ‘USAGE IS DISPLAY’<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Picture mask USAGE option was overridden by the picture mask.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0This is an informational message only. The message may be eliminated by changing the USAGE option to match the picture mask.<\/span><\/span><\/p>\n

\n
<\/a> ORA-08499: Warning: picture mask options ‘string<\/i>‘ ignored by UTL_PG<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Picture mask options such as OCCUR, SYNC and others are not processed by the UTL_PG numeric conversion routines.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0This 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.<\/span><\/span><\/p>\n

\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-08400 to ORA-08600 ORA-08401: invalid compiler name:\u00a0string Cause:\u00a0An invalid compiler name\u00a0compname\u00a0was passed to a UTL_PG conversion routine. Action:\u00a0Correct the compiler name parameter in the PL\/SQL code that called the conversion routine. ORA-08402: error executing PL\/SQL code coverage Cause:\u00a0An error occurred during execution of a PL\/SQL code…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[54],"class_list":["post-2172","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-z2","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2172","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=2172"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2172\/revisions"}],"predecessor-version":[{"id":2173,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2172\/revisions\/2173"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2172"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2172"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}