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-13629: The task or object string is being used by another operation.

1 Answers  


ORA-24329: invalid character set identifier

1 Answers  


O2F-00306: Unable to close the INTYPE file

1 Answers  


DRG-11616: URL store: too many redirections trying to access string

1 Answers  


UDI-00013: internal impdp error.

1 Answers  






ORA-14172: invalid ALTER TABLE EXCHANGE SUBPARTITION option

1 Answers  


ORA-16767: Logical apply service unexpectedly online

1 Answers  


PCC-02346: PL/SQL found semantic errors

1 Answers  


TNS-01036: %s established:string refused:string

1 Answers  


ORA-30378: MV_CAPABILITIES_TABLE is not compatible with Oracle version

1 Answers  


ORA-16093: dependent archive log destination is not LGWR-enabled

1 Answers  


ORA-29327: unsupported client compatibility mode used when talking to the server

1 Answers  


Categories