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


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-06029: NETASY: port assignment failure

1 Answers  


ORA-08102: index key not found, obj# string, file string, block string (string)

1 Answers  


ORA-12015: cannot create a fast refresh materialized view from a complex query

1 Answers  


ORA-26693: STREAMS string process dropped successfully, but error occurred while dropping rule set string

1 Answers  


ORA-07488: scgrcl: lock manager not initialized.

1 Answers  






PLS-00310: with %%ROWTYPE attribute, 'string' must name a table, cursor or cursor-variable

1 Answers  


TNS-01066: Presentation: string

1 Answers  


ORA-02807: Allocation of memory for I/O vectors failed.

1 Answers  


LSX-00133: attribute "use" has invalid value "~S"

1 Answers  


ORA-13866: Client identifier must be specified

1 Answers  


ORA-03297: file contains used data beyond requested RESIZE value

1 Answers  


ORA-12489: default label not within clearance range

1 Answers  






Categories