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-07848: sllfrb: $GET failure

1 Answers  


TNS-00088: * exit - quit the Interchange controller

1 Answers  


ORA-09704: sstascre: ftok error in creating test and set pages.

1 Answers  


TNS-12198: TNS:could not find path to destination

1 Answers  


NZE-29022: Operation is being attempted on the wrong side of the client/server connection.

1 Answers  






ORA-25450: error string during evaluation of rule set string.string

1 Answers  


PCC-00102: FOR UPDATE is an Oracle extension

1 Answers  


PCC-02307: void can only be used when single parameter

1 Answers  


ORA-16806: Supplemental logging is not turned on.

1 Answers  


ORA-26002: Table string has index defined upon it.

1 Answers  


ORA-16525: the Data Guard broker is not yet available

2 Answers  


ORA-12825: explicit degree of parallelism must be specified here

1 Answers  


Categories