PLS-00117: Duplicate connect-by clause in table expression
- 1 Answers
- 2535 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: Two or more CONNECT BY clauses were found in a SELECT
statement. The CONNECT BY clause defines a relationship used
to return rows in a hierarchical order. The relationship can
contain two expressions separated by a relational operator
(such as = or !=), but a statement can contain only one
CONNECT BY clause.
Action: Remove one of the CONNECT BY clauses and, if
necessary, separate expressions by a relational operator.
Please add more information about this Error
| Is This Answer Correct ? | 1 Yes | 0 No |
ORA-31435: an error occurred during the purge operation
ORA-00080: invalid global area specified by level string
ORA-32846: Messaging Gateway agent cannot be started; status is string
ORA-07305: ksmcsg: illegal database buffer size.
ORA-00155: cannot perform work outside of global transaction
ORA-31076: required attribute "string" not specified
NNL-00985: Requests reforwarded using referrals: number
ORA-15036: disk 'string' is truncated
ORA-27468: "string.string" is locked by another process
QSM-01509: equivalence, string, matched query text
ORA-07469: sppst: mclear error, unable to clear semaphore.
ORA-01180: can not create datafile 1
Oracle Errors 
