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-27065: cannot perform async vector I/O to file

1 Answers  


ORA-29338: datafile string is in an undesired state (string, string)

1 Answers  


ORA-24142: invalid ruleset name

1 Answers  


IMG-00870: unsupported aspect ratio or image size

1 Answers  


RMAN-03019: asynchronous RPCs are NOT working

1 Answers  






ORA-28542: Error in reading HS init file

1 Answers  


ORA-27547: Unable to query IPC OSD attribute string

1 Answers  


RMAN-06550: clone database not mounted and db_name not set in init.ora

1 Answers  


ORA-01480: trailing null missing from STR bind value

1 Answers   IBM,


ORA-01030: SELECT ... INTO variable does not exist

1 Answers  


PCC-00045: %s clause inappropriate at line number in file string. Ignored.

1 Answers  


ORA-07849: sllfsk: $GET failure

1 Answers  


Categories