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

NCR-03012: NCRO: Invalid session mode

1 Answers  


LCD-00111: value not in legal range [string]

1 Answers  


ORA-32617: missing MEASURES keyword in MODEL clause

1 Answers  


RMAN-03010: fatal error during library cache pre-loading

1 Answers  


PLS-00399: different types of columns in UNION, INTERSECT, or MINUS expression

1 Answers  






ORA-02809: Jump buffer not valid

1 Answers  


LRM-00122: value 'string' for 'string' must be between 'number' and 'number'

1 Answers  


ORA-07224: sfnfy: failed to obtain file size limit; errno = string.

1 Answers  


DRG-12400: template string is empty

1 Answers  


DRG-50805: failed to close cursor

1 Answers  


ORA-16145: archival for thread# string sequence# string in progress

1 Answers  


NNF-02002: NIS value does not conform to adapter schema: string

1 Answers  


Categories