PLS-01708: In searched DELETE, UPDATE or INSERT, table must not appear in FROM

PLS-01708: In searched DELETE, UPDATE or INSERT, table must
not appear in FROM clause of subqueries in search condition

Question Posted / guest

1 Answers
2510 Views
I also Faced
E-Mail Answers

PLS-01708: In searched DELETE, UPDATE or INSERT, table must not appear in FROM clause of subqueries..

Answer / guest

Cause: In a searched DELETE, UPDATE or INSERT statement, the
table affected must not appear in a FROM clause in any of
the subqueries in the search condition.

Action: none

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-29506: invalid query derived from USING clause

1 Answers

ORA-09890: osnTXtt: malloc failed

1 Answers

PLS-01460: Cannot access object on a remote host

1 Answers

ORA-16750: Resource guard encountered errors while activating logical primary

1 Answers

ORA-01517: log member: 'string'

1 Answers

ORA-24183: invalid transformation

1 Answers

ORA-06712: TLI Driver: error on accept

1 Answers

NNL-00890: Messages received: number

1 Answers

QSM-02154: MV is not fast refreshable even with view merging

1 Answers

ORA-04097: DDL conflict while trying to drop or alter a trigger

1 Answers

ORA-06511: PL/SQL: cursor already open

1 Answers

ORA-29341: The transportable set is not self-contained

1 Answers

For more Oracle Errors Interview Questions Click Here