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

TNS-01025: Security string

1 Answers  


PCC-02410: Expecting an expression of some Collection type.

1 Answers  


KUP-04084: The ORACLE_DATAPUMP access driver does not support the ROWID column.

1 Answers  


PCB-00603: An EXEC TOOLS MESSAGE host variable is not a character type

1 Answers  


ORA-02256: number of referencing columns must match referenced columns

1 Answers  






ORA-10586: Test recovery had to corrupt 1 data block in order to proceed

1 Answers  


AMD-00119: analytic workspace dimensions not specified in input

1 Answers  


ORA-03214: File Size specified is smaller than minimum required

1 Answers  


ORA-13903: Invalid combination of string threshold value and operator.

1 Answers  


ORA-30203: Cannot open mesage file

1 Answers  


QSM-01069: summary join graph for, string, does not have table, string

1 Answers  


NZE-28779: no data access method specified in parameter

1 Answers  


Categories