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
2603 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

TNS-00007: INTCTL: unknown host

1 Answers

KUP-04045: unexpected OCI status string

1 Answers

ORA-00365: the specified log is not the correct next log

1 Answers

ORA-01507: database not mounted

1 Answers

ORA-22924: snapshot too old

1 Answers

ORA-03288: both FREELIST GROUP and INSTANCE parameters may not be specified

1 Answers

PCB-00217: OCCURS INDEXED clause not allowed for host variable "string"

1 Answers

ORA-24041: propagation schedule exists for QUEUE string and DESTINATION string

1 Answers

NNL-00404: TTL: string

1 Answers

ORA-14157: invalid subpartition name

1 Answers

ORA-36710: (XSMXALLOC01) TARGETLOG variable workspace object must be dimensioned identically to TARGET variable workspace object.

1 Answers

ORA-22978: only simple attribute name is allowed in the WITH OBJECT OID clause

1 Answers

For more Oracle Errors Interview Questions Click Here