PCB-00210: DISPLAY-1 only allowed with PIC G and PIC N
variables "string"



PCB-00210: DISPLAY-1 only allowed with PIC G and PIC N variables "string"..

Answer / guest

Cause: A variable declared with DISPLAY-1 in the usage
clause without PIC G or PIC N in the picture clause was used
in a SQL statement.

Action: Replace DISPLAY-1 with DISPLAY or change the picture
clause to use PIC N or PIC G.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01287: file string is from a different database incarnation

1 Answers  


RMAN-05016: failover to previous backup

1 Answers  


ORA-31652: command response message was invalid type - detaching job

1 Answers  


ORA-32303: mviews with user-defined types cannot reference multiple master sites

1 Answers  


ORA-01898: too many precision specifiers

1 Answers  






PCB-00700: This statement can only be used with DYNAMIC=ANSI

1 Answers  


PCB-00104: Unable to open input file "string"

1 Answers  


TNS-01057: Program name: string

1 Answers  


IMP-00078: Cannot translate FILE locator to "string" "string" in server character set

1 Answers  


RMAN-06748: no or more than one tertiary storage channel found

1 Answers  


ORA-04032: pga_aggregate_target must be set before switching to auto mode

1 Answers  


RMAN-00565: unable to read input file

1 Answers  


Categories