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
2608 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-02762: file number to be cancelled is greater than the maximum.

1 Answers

KUP-03009: OCI error getting column name.

1 Answers

ORA-19595: archivelog string already included in backup conversation

1 Answers

KUP-04040: file string in string not found

1 Answers

ORA-13037: SRIDs do not match for the two geometries

1 Answers

TNS-02516: No data available

1 Answers

ORA-09910: Unable to find ORACLE password file entry for user.

2 Answers

NNL-00018: warning: could not contact default name server

1 Answers

O2F-00302: Unable to allocate memory

1 Answers

ORA-25139: invalid option for CREATE TEMPORARY TABLESPACE

1 Answers

ORA-13768: Snaphshot ID must be between string and string.

1 Answers

RMAN-08121: keep attributes for the backup are deleted

1 Answers

For more Oracle Errors Interview Questions Click Here