PCB-00209: Scale is not supported for host variable "string"



PCB-00209: Scale is not supported for host variable "string"..

Answer / guest

Cause: A variable whose format does not support scaling was
used in a SQL statement or embedded PL/SQL block. The
following formats do not support scaling: PIC S9(n) COMP PIC
S9(n) COMP-4 PIC S9(n) COMP-5 PIC S9(n) BINARY PIC 9(n) COMP

Action: Remove the scale or use a datatype that support scaling.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-25288: AQ HTTP propagation encountered error, status-code number, string

1 Answers  


ORA-27147: post/wait reset failed

1 Answers  


ORA-01505: error in adding log files

1 Answers  


ORA-10582: The control file is not a backup control file

1 Answers  


NZE-28780: invalid data access method specified by the parameter

1 Answers  






DRG-11612: URL store: unknown host specified in string

1 Answers  


PLS-00644: character set mismatch found at 'string' among result expressions in a CASE expression

1 Answers  


PLS-00360: cursor declaration without body needs return type

1 Answers  


RMAN-12020: error on step filtered for normal output string

1 Answers  


ORA-32845: Messaging Gateway agent is already running

1 Answers  


ORA-19707: invalid record block number - string

1 Answers  


LSX-00122: value is not valid restriction of parent's whiteSpace

1 Answers  


Categories