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-07277: spdde: illegal pid passed as argument.

1 Answers  


ORA-30041: Cannot grant quota on the tablespace

1 Answers  


ORA-19921: maximum number of string rows exceeded

1 Answers  


NNO-00318: overriding next statistic counter reset, resetting in number seconds

1 Answers  


PCC-01513: FIPS warning: Unsupported datatype in line number of file string

1 Answers  






DGM-16917: Unable to shut down instance "string".

1 Answers  


ORA-22863: synonym for datatype string.string not allowed

1 Answers  


DRG-50804: failed to exec cursor

1 Answers  


TNS-12505: TNS:listener does not currently know of SID given in connect descriptor

1 Answers   Wipro,


ORA-22053: overflow error

1 Answers  


ORA-06026: NETASY: port close failure

1 Answers  


ORA-10572: Test recovery canceled due to errors

1 Answers  


Categories