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

SQL*Loader-00904: You cannot used the direct path when linked with v5 of the database

1 Answers  


TNS-12209: TNS:encountered uninitialized global

1 Answers  


ORA-13265: geometry identifier column string in table string is not of type NUMBER

1 Answers  


QSM-01009: materialized view, string, matched query text

1 Answers  


ORA-19586: %s k-byte limit is too small to hold piece directory

1 Answers  






NID-00301: Datafile string - dbid changed, wrote new name

1 Answers  


ORA-01144: File size (string blocks) exceeds maximum of string blocks

2 Answers  


EXP-00047: Missing tablespace name(s)

1 Answers  


ORA-38102: Invalid column in the INSERT WHERE Clause: string

1 Answers  


ORA-31069: Cannot apply typed changes to non-schema-based XMLType nodes

1 Answers  


ORA-06441: ssvwatev: Incorrect parameter passed to function call

1 Answers  


SQL*Loader-00433: no attributes found for column object string in table string

1 Answers  


Categories