Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-09872: TASDEF_CREATE: create failure in creating ?/dbs/tasdef@.dbf.

1 Answers  


LPX-00657: Invalid output PI '~S'.

1 Answers  


LSX-00121: value is not valid restriction of parent's length

1 Answers  


RMAN-06463: Backup set key string cannot be backed up by proxy.

1 Answers  


ORA-13113: invalid tg_layer_id in sdo_topo_geometry constructor

1 Answers  






TNS-01302: nr err code: number

1 Answers  


ORA-26025: SKIP_INDEX_MAINTENANCE option requested

1 Answers  


ORA-08458: invalid format parameter

1 Answers  


DRG-10513: index string metadata is corrupt

1 Answers  


ORA-06742: TLI Driver: cannot alloc t_bind

1 Answers  


ORA-17503: ksfdopn:string Failed to open file string

1 Answers  


ORA-07702: unrecognized device type in archive text

1 Answers  






Categories