ORA-08459: invalid format parameter length



ORA-08459: invalid format parameter length..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-14267: cannot specify PARALLEL clause when adding a (Composite) Range partition

1 Answers  


TNS-00301: ***Enabling Interchange : string

1 Answers  


ORA-02229: invalid SIZE option value

1 Answers  


ORA-13629: The task or object string is being used by another operation.

1 Answers  


ORA-30024: Invalid specification for CREATE UNDO TABLESPACE

1 Answers  






ORA-09954: scgcc: unexpected return status to callback of lock close

1 Answers  


ORA-00437: ORACLE feature is not licensed. Contact Oracle Corp. for assistance

1 Answers  


ORA-36392: (XSMXCLEA02) When using CLEAR with the PRECOMPUTES or NONPRECOMPUTES options, you must supply an AGGMAP.

1 Answers  


PLS-00732: Illegal overload of ellipsis in formal parameter list

1 Answers  


ORA-16511: messaging error using ksrget

1 Answers  


SQL*Loader-00475: field for dynamic file name is string in table string

1 Answers  


ORA-01551: extended rollback segment, pinned blocks released

1 Answers  


Categories