PLS-00521: ORDER methods must be declared with 1 (one)
parameter in addition to (optional) SELF.



PLS-00521: ORDER methods must be declared with 1 (one) parameter in addition to (optional) SELF...

Answer / guest

Cause: An order member function was declared without the
user-specified parameter. Order member functions have two
parameters, one is the default SELF parameter which is added
by the compiler. the second parameter is added by the user
and must declare an order method which must be the same type
as the containing object type.

Action: Check and correct the way the parameter is specified.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-06533: Subscript beyond count

1 Answers  


QSM-01120: recursive rewrite not allowed here

1 Answers  


TNS-04235: Trace Assistant WARNING: Unknown TTC protocol

1 Answers  


PCC-00001: Unable to open file string

1 Answers  


TNS-00507: Connection closed

1 Answers  


NZE-28832: invalid data unit format

1 Answers  


ORA-31072: Too many child nodes in XMLType fragment for updateXML

1 Answers  


RMAN-06708: short write while writing file "string". Wrote string bytes instead of string bytes

1 Answers  


ORA-00383: DEFAULT cache for blocksize string cannot be reduced to zero

1 Answers  


ORA-16751: Resource guard encountered errors in switchover to primary

1 Answers  


TNS-12557: TNS:protocol adapter not loadable

2 Answers  


ORA-06132: NETTCP: access denied, wrong password

1 Answers  


Categories