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-19769: missing FILE keyword

1 Answers  


TNS-12533: TNS:illegal ADDRESS parameters

1 Answers  


RMAN-02004: quoted string too big

1 Answers  


ORA-02058: no prepared transaction found with ID string

1 Answers  


NNO-00624: setting auto-refresh expiration period to number seconds

1 Answers  






ORA-01633: Real Application Clusters Option needed for this operation

1 Answers  


ORA-22609: error string during initialization of FDO

1 Answers  


ORA-30363: columns in a dimension column list must be in the same relation

1 Answers  


ORA-02426: privilege grant failed

1 Answers  


ORA-12915: Cannot alter dictionary managed tablespace to read write

1 Answers  


PLS-00588: unqualified instance attribute references allowed only in member methods

1 Answers  


PCB-00629: Host variable is not of Internal LOB type

1 Answers  


Categories