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-06917: CMX: error in data read (too many bytes read)

1 Answers  


ORA-14260: incorrect physical attribute specified for this partition

1 Answers  


LFI-00125: Random access only allowed on fixed length record files.

1 Answers  


AMD-00101: cannot create string "string"; metadata entity already exists

1 Answers  


ORA-06446: ssvpstevrg: Failed with unexpected error number.

1 Answers  






ORA-22153: source variable-length array is not initialized

1 Answers  


RMAN-03014: implicit resync of recovery catalog failed

1 Answers  


ORA-14624: DEFAULT subpartition must be last subpartition specified

1 Answers  


NNL-00932: Requests refused, type syntax mismatch: number

1 Answers  


PCC-01017: The SQLCA and a SQLCODE variable cannot both be used

1 Answers  


RMAN-20280: too many device types

1 Answers  


ORA-12043: invalid CREATE MATERIALIZED VIEW option

1 Answers  


Categories