Forum Stats

  • 3,875,380 Users
  • 2,266,909 Discussions
  • 7,912,186 Comments

Discussions

SQL Update command send me "ORA-00903: invalid table name" error

Jean-Baptiste Marotte
Jean-Baptiste Marotte Member Posts: 2 Green Ribbon

Hi all,

My query works well with SELECT command but, when I try to use the UPDATE command, I have the error listed above.

There is my query :

update PER_EMAIL_ADDRESSES 

set EMAIL_ADDRESS='[email protected]'

where EMAIL_ADDRESS_ID=(select CAND_EMAIL_ID

from IRC_CANDIDATES

where CANDIDATE_NUMBER=1123028

)


Could you explain me what's wrong here ?

Tagged:

Answers