Results for ORDER


81 to 100 of 2659 results. Prev  Next
Results per page:   20  | 40 | 60


Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00654 PARTITION/ORDER/CLUSTER BY is only allowed for with PARALLEL_ENABLECause: An attempt was made to use either PARTITION BY, ORDER BY, or CLUSTER BY clauses without … parallel enable clause in table function. Action: Specify parallel enable also when using PARTITION BY, CLUSTER BY, or ORDER BY clauses.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-01500 to ORA-02099

ORA-01785 ORDER BY item must be the number of a SELECT-list expressionCause: Either an ORDER BY item for a set expression is not a column number, or the ORDER BY item is … not the number of a SELECT list column. Action: The ORDER BY item must be a number between 1 and

Error Messages, 9i Release 2 (9.2.0.2)

ORA-09858 to ORA-12299

ORA-10589 Test recovery had to corrupt string data blocks in order to proceedblocks as specified in the message in order to apply the range of redo tested. Action: See the alert log for details of the problems.

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00527 MAP or ORDER functions require a PRAGMA RESTRICT_REFERENCES specifying :WNDS,WNPS,RNPS,RNDS.Cause: Either a PRAGMA RESTRICT_REFERENCES was not specified or it was specified without one of the following: WNDS, WNPS, RNPS, or RNDS. Action: Add or correct the PRAGMA and retry the operation.

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00528 The parameters to an ORDER function must have IN modeCause: A parameter was declared to an ORDER function to have OUT or IN OUT mode. Action: Correct the parameter to use IN mode only.

SQL Reference, 9i Release 2 (9.2.0.2)

Preface

Chapters 9 through 18 list and describe all Oracle SQL statements in alphabetical order.Appendix A, \"How to Read Syntax Diagrams\" This appendix describes how to read the syntax diagrams in this reference. Appendix B, \"Oracle and Standard SQL\"

Error Messages, 9i Release 2 (9.2.0.2)

ORA-29250 to ORA-32799

ORA-30435 job_queue_processes must be non-zero in order to refresh summariesCause: The server must be started with parameter JOB_QUEUE_PROCESSES greater than zero. Action: Correct the value of JOB_QUEUE_PROCESSES and restart the server instance.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-09858 to ORA-12299

ORA-10586 Test recovery had to corrupt 1 data block in order to proceedCause: This message summarizes test recovery result: Oracle may have to corrupt one block in order

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00646 MAP or ORDER method must be defined in the root of the subtype hierarchyCause: An attempt was made to define a MAP or ORDER method in a subtype. Action: Define the MAP or … ORDER method in the root of the subtype hierarchy. You can override MAP methods in subtypes.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-19400 to ORA-24279

ORA-19611 backup piece out of order. Expected string but found stringCause: This backup piece is out of sequence. Action: Supply the correct backup piece.

Error Messages, 9i Release 2 (9.2.0.2)

External Tables Messages (KUP)

KUP-04091 little endian byte order mark found when big endian expected in stringCause: A little endian byte order mark was found at the beginning of the specified file. Either the … access parameters specified that the data was in big endian order or the byte order mark for a … previous file was big endian. Action: The file needs to be loaded separately. If a byte order was

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00526 A MAP or ORDER function is required for comparing objects in PL/SQL.Cause: Within stand alone PL/SQL, an attempt was made to compare objects without a map or order … function. Action: Provide a map or order function and retry the operation.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-02100 to ORA-04099

ORA-02813 Unable to make temporary file name in order to get keyCause: This is an internal error. Action: Contact Oracle Support Services.

Error Messages, 9i Release 2 (9.2.0.2)

Oracle Text Messages (DRG)

DRG-10846 order by columns must be all ascending or all descendingCause: An ORDER BY clause was specified which has some columns ascending and some descending. This is not currently supported by CATSEARCH. Action:

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00155 Only a function may be a MAP, ORDER or CONSTRUCTOR method.Cause: A procedure was declared as a MAP, ORDER, or CONSTRUCTOR method. Only functions can be MAP … , ORDER, or CONSTRUCTOR methods. Action: Change the procedure to a function.

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00423 ORDER BY item must be the number of a SELECT-list expressionCause: A column alias was used in the ORDER BY clause of a SELECT statement that uses a UNION … , INTERSECT, or MINUS set operator. This is not allowed. In such cases, expressions in the ORDER BY clause … the alias in the ORDER BY clause to an unsigned integer that designates the ordinal position of the select item in question.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-19400 to ORA-24279

ORA-22315 type \" string \" does not contain a map or order functionCause: The input type does not contain a map or order function so one cannot be returned. Action … : Add a map or order function to the type or catch this error.

Error Messages, 9i Release 2 (9.2.0.2)

External Tables Messages (KUP)

KUP-04090 big endian byte order mark found when little endian expected in stringCause: A big endian byte order mark was found at the beginning of the specified file. Either the … access parameters specified that the data was in little endian order or the byte order mark for a … previous file was little endian. Action: The file needs to be loaded separately. If a byte order was

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00154 An object type may have only 1 MAP or 1 ORDER method.Cause: More than one map or order function was declared. An object type can have only one map … function or one order function, but not both. Action: Delete all but one of the MAP or ORDER functions on the type.

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00521 ORDER methods must be declared with 1 (one) parameter in addition to (optional) SELF.Cause: An order member function was declared without the user-specified parameter. Order member … second parameter is added by the user and must declare an order method which must be the same type as





Was this page helpful?

Integrated Cloud Applications & Platform Services