Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


PCB-00211: VARYING not supported with PIC N or PIC G
variable "string"



PCB-00211: VARYING not supported with PIC N or PIC G variable "string"..

Answer / guest

Cause: The keyword VARYING was used in a PIC N variable
declaration.

Action: Remove the keyword VARYING from the variable
declaration. If you want to declare a PIC N VARCHAR
variable, specify the precompiler option VARCHAR=YES and
declare the variable as an implicit VARCHAR group item as
illustrated by the following example: EXEC SQL BEGIN DECLARE
SECTION END-EXEC. ... 01 ENAME. 05 ENAME-LEN PIC S9(4) COMP.
05 ENAME-ARR PIC N(20). ... EXEC SQL END DECLARE SECTION
END-EXEC.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-24270: a row already exists in the string table for these parameters

1 Answers  


ORA-36398: (XSSPROP01) Property name 'number' is invalid because only system-reserved property names can begin with "$".

1 Answers  


QSM-01079: DML operation occurred on a table referenced by MV, string

1 Answers  


ORA-00128: this command requires a dispatcher name

1 Answers  


ORA-07715: sksadtd: could not dismount archival device (SYS$DISMNT failure)

1 Answers  


PCB-00322: EXEC SQL LOB statements an Oracle extension

1 Answers  


EXP-00037: Export views not compatible with database version

1 Answers  


ORA-23389: obsolete procedure; drop objects and recreate using new master

1 Answers  


ORA-12983: cannot drop all columns in a table

1 Answers  


ORA-15047: ASM file name 'string' is not in multiple-file creation form

1 Answers  


ORA-28611: bitmap index is corrupted - see trace file for diagnostics

1 Answers  


ORA-09274: szrfc: insufficient role name buffer space

1 Answers  


Categories