PCB-00212: PICTURE clause not allowed for host variable "string"



PCB-00212: PICTURE clause not allowed for host variable "string"..

Answer / guest

Cause: A variable declared with a PIC clause and COMP-1 or
COMP-2 was used in a SQL statement or embedded PL/SQL block.

Action: Remove the PIC clause or use a datatype other than
COMP-1 or COMP-2 in the declaration of the variable.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-27509: IPC error receiving a message

1 Answers  


NNL-00895: Requests refused, processing disabled: number

1 Answers  


ORA-12566: TNS:protocol error

1 Answers  


ORA-10655: Segment can be shrunk

1 Answers  


LPX-00017: ~1sNodeName: <~2S>

1 Answers  


ORA-07205: slgtd: time error, unable to obtain time.

1 Answers  


DRG-10314: logging has not been started

1 Answers  


ORA-00956: missing or invalid auditing option

1 Answers  


ORA-23395: object "string"."string" of type "string" does not exist or is invalid

1 Answers  


ORA-31452: invalid value string for parameter, expecting: Y or N

1 Answers  


ORA-30937: No schema definition for 'string' (namespace 'string') in parent 'string'

1 Answers  


PCB-00200: Cannot equivalence PIC N or PIC G variable "string"

1 Answers  


Categories