Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

DRG-51301: error releasing dml Queue lock

1 Answers  


ORA-01105: mount is incompatible with mounts by other instances

1 Answers  


PCC-02435: This attribute is only valid for internal LOB types

1 Answers  


NID-00144: New name for database string is the same as current name string

1 Answers  


LSX-00146: element or attribute is improperly defined

1 Answers  






DRG-52201: imcompatible Oracle Text versions

1 Answers  


CLSR-06506: Error number encountered when executing string

1 Answers  


LPX-00217: invalid character ~1u (~2x)

1 Answers  


KUP-04063: unable to open log file string OS error string

1 Answers  


ORA-06265: NETNTT: break protocol error

1 Answers  


ORA-01426: numeric overflow

1 Answers  


TNS-12196: TNS:received an error from TNS

1 Answers  






Categories