ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  ERRORS  >>  Database Errors  >>  Oracle Errors
 
 


 

 
 Oracle Errors interview questions  Oracle Errors Interview Questions
 SQLServer Errors interview questions  SQLServer Errors Interview Questions
 MySQL Errors interview questions  MySQL Errors Interview Questions
Question
PCC-01014: "VARYING" not supported with PIC N PICTURE clause
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: PCC-01014: "VARYING" not supported with PIC N PICTURE clause
Answer
# 1
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
Guest
 

 
 
 
Other Oracle Errors Interview Questions
 
  Question Asked @ Answers
 
ORA-27300: OS system dependent operation:string failed with status: string  1
ORA-24355: attempt to store a negative number in an Unsigned Display type.  1
ORA-06107: NETTCP: ORACLE network server not found  1
ORA-25269: cant specify sognature with get signature option  1
ORA-24420: OCISessionRelease must be used to release this session.  1
SQL*Loader-00552: insufficient privilege to open file  1
ORA-19769: missing FILE keyword  1
IMP-00081: attempt to free unallocated memory  1
RMAN-06582: AS COPY option cannot be used when backing up backupsets  1
ORA-28504: ROWID not found in ROWID cache for heterogeneous database link  1
ORA-02285: duplicate START WITH specifications  1
ORA-07416: slpath: pathname construction failed; lack of output buffer space.  1
RMAN-03008: error while performing automatic resync of recovery catalog  1
ORA-33918: (MAKEDCL33) You cannot define a surrogate of dimension workspace object because it is a string.  1
ORA-01238: cannot shrink datafile string  1
ORA-02300: invalid value for OIDGENERATORS  1
SQL*Loader-00481: HIDDEN may not be used with non-scalar fields.  1
NZE-29033: Invalid PFX  1
RMAN-06513: copy will never be obsolete  1
ORA-36692: (XSRELTBL00) The format of the HIERHEIGHT command is: HIERHEIGHT relation1[(dimension dimvalue, ...)] into relation2 [using relation3 | a | d] [inhierarchy {variable | valueset}].  1
 
For more Oracle Errors Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com