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-37106: (XSVPART06) Invalid partition name number.

1 Answers  


ORA-38447: Type required for the embedded ADT attribute "string" is missing

1 Answers  


NID-00400: DBNEWID - Completed with errors.

1 Answers  


NID-00126: Database should have no datafiles in unknown state

1 Answers  


ORA-01281: SCN range specified is invalid

1 Answers  


ORA-06606: LU6.2 Driver: Unexpected response from SNA

1 Answers  


ORA-07513: sscgctl: $deq unexpected return on cancel of term. lock

1 Answers  


ORA-26688: missing key in LCR

1 Answers  


ORA-02813: Unable to make temporary file name in order to get key

1 Answers  


IMG-00814: fail queue free failed

1 Answers  


ORA-00398: abort thread recovery due to reconfiguration

1 Answers  


PCC-02201: Found syntax error

1 Answers  


Categories