ORA-00976: LEVEL, PRIOR, or ROWNUM not allowed here

Answers were Sorted based on User's Feedback



ORA-00976: LEVEL, PRIOR, or ROWNUM not allowed here..

Answer / geetanjali pandey

This error may when localization is not able to retrieve the
country from location of organization , while creating
location of an organization address field is entered in this
country field should be filled that the location belongs to
which country , this is one of the reason.

Is This Answer Correct ?    1 Yes 0 No

ORA-00976: LEVEL, PRIOR, or ROWNUM not allowed here..

Answer / guest

Cause: LEVEL, PRIOR, or ROWNUM is being specified at illegal
location.

Action: Remove LEVEL, PRIOR, or ROWNUM.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 6 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01151: use media recovery to recover block, restore backup if needed

1 Answers  


DRG-50100: CORE LSF error: string

1 Answers  


ORA-12622: TNS:event notifications are not homogeneous

1 Answers  


DRG-50935: parser component failure

1 Answers  


ORA-22895: referenced table "string" in schema "string" is not an object table

1 Answers  






ORA-13633: The task string was interrupted and needs to be resumed.

1 Answers  


ORA-26690: datatype not supported at non-Oracle system

1 Answers  


QSM-00799: the user-defined workload table string cannot be found

1 Answers  


TNS-04207: Trace Assistant Internal ERROR: Packet Length

1 Answers  


DRG-12308: use ctx_ddl.create_index_set to create index sets

1 Answers  


ORA-22304: input type is not an object type

1 Answers  


TNS-01177: Log Status is OFF. Log file/directory unchanged

1 Answers  


Categories