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

PCB-00223: Undeclared variable "string"

1 Answers  


ORA-12027: duplicate filter column

1 Answers  


UDE-00017: Data Pump job is already executing.

1 Answers  


NID-00100: Cannot open datafile "string"

1 Answers  


ORA-23384: replication parallel push string argument out of range

1 Answers  






ORA-17613: Failed to initialize Oracle Disk Manager library: string

1 Answers  


RMAN-06528: CHANGE ... KEEP not supported for BACKUPPIECE

1 Answers  


ORA-14500: LOCAL option not valid without partition name

1 Answers  


ORA-02782: Both read and write functions were not specified

1 Answers  


RMAN-08085: created script string

1 Answers  


PCB-00638: This attribute is only valid for internal or external LOB types

1 Answers  


NZE-29022: Operation is being attempted on the wrong side of the client/server connection.

1 Answers  


Categories