PCB-00216: OCCURS ASCENDING/DESCENDING clause not allowed
for "string"



PCB-00216: OCCURS ASCENDING/DESCENDING clause not allowed for "string"..

Answer / guest

Cause: A variable declared with an OCCURS clause with the
ASCENDING or DESCENDING KEY IS subclause was used in a SQL
statement or embedded PL/SQL block.

Action: Remove the ASCENDING or DESCENDING KEY IS subclause
from the variable declaration.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-08184: attempting to re-enable Flashback while in Flashback mode

1 Answers  


TNS-01403: Load: string

1 Answers  


NID-00122: Database should have no offline immediate datafiles

1 Answers  


ORA-34350: (MXDSS06) string is an open analytic workspace.

1 Answers  


DRG-10016: you must be the owner to modify this object

1 Answers  






ORA-15114: missing or invalid ASM file name

1 Answers  


DRG-11523: unable to lock the specified row for update

1 Answers  


ORA-01742: comment not terminated properly

1 Answers  


ORA-28663: Logging/Nologging attribute can not be specified in the statement ALTER TABLE ADD OVERFLOW

1 Answers  


NNO-00333: warning: ROS admin_region types obsolete; using SQL

1 Answers  


SQL*Loader-00811: error dropping external table: string

1 Answers  


ORA-02353: files not from the same unload operation

1 Answers  


Categories