PLS-00625: PARTITION/CLUSTER/ORDER-BY clause can only be
used with IN parameters



PLS-00625: PARTITION/CLUSTER/ORDER-BY clause can only be used with IN parameters..

Answer / guest

Cause: A PARTITION/CLUSTER/ORDER-BY clause was used with an
OUT or IN OUT ref-cursor parameter.

Action: Change the parameter mode to IN or use some other
parameter with the PARTITION/CLUSTER/ORDER-BY clause.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-31438: duplicate change table string

1 Answers  


ORA-16020: less destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST

1 Answers  


TNS-12631: Username retrieval failed

1 Answers  


NID-00402: Must finish change or REVERT changes before attempting any database operation.

1 Answers  


AMD-00109: Parent metadata entity has too many child entities. string "string" has more than string string

1 Answers  






SQL*Loader-00925: Error while string

1 Answers  


TNS-00005: INTCTL: error while sending request to the Navigator

1 Answers  


RMAN-08153: deleted global script: string

1 Answers  


CLSS-00001: skgxn not active

1 Answers  


QSM-02074: materialized view over Heterogeneous Services link

1 Answers  


ORA-24342: unable to destroy a mutex

1 Answers  


RMAN-06582: AS COPY option cannot be used when backing up backupsets

1 Answers  


Categories