PCC-01015: Cannot equivalence PIC N variable string



PCC-01015: Cannot equivalence PIC N variable string..

Answer / guest

Cause: A PIC N variable or an implicit VARCHAR group item
(with a PIC N variable as an elementary item) was used in an
EXEC SQL VAR statement. This is not allowed.

Action: Do not use the PIC N variable in an EXEC SQL VAR
statement. If you want an equivalence to an Oracle type
using an EXEC SQL VAR statement, use a PIC X variable,
instead of a PIC N variable.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16756: Resource guard could not open standby readonly

1 Answers  


ORA-24801: illegal parameter value in OCI lob function

1 Answers  


ORA-36716: (XSMXALLOC04) You can only use the ACROSS phrase when allocation BASIS workspace object is a FORMULA.

1 Answers  


QSM-01013: nested aggregates or CONNECT BY/START WITH clause present

1 Answers  


ORA-26563: renaming this table is not allowed

1 Answers  






KUP-03021: clause references unknown field string

1 Answers  


ORA-07618: $IDTOASC failed translating a secrecy level

1 Answers  


ORA-07820: sspscn: SYS$CRELNM failure

1 Answers  


ORA-36378: (XSAGTHRWEIGHT) While running AGGREGATE with multiple threads, the weight variable workspace object specified by your ARGS variable workspace object must exist in the same analytic workspace as your AGGMAP workspace object.

1 Answers  


TNS-00239: Connection Manager has been stopped

1 Answers  


ORA-26530: unable to build materialized view refresh control list

1 Answers  


TNS-00125: Failed to get number of Interchanges in TNSNET.ORA

1 Answers  


Categories