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

Jean-Baptiste Marotte

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 ?

Lothar Armbrüster

As a wild guess I would think that PER_EMAIL_ADDRESSES is a view and not a table.

Hope that helps.

Frank Kulash

Hi, @Jean-Baptiste Marotte

My query works well with SELECT command

Post the SELECT command, or even better, a complete test script so we can re-create the problem.

but, when I try to use the UPDATE command, I have the error listed above.

Which table does it say is not found? Always post the full error message.

Jean-Baptiste Marotte

Hi @Frank Kulash ,

Thanks for your answer.

This select command works well:

select email_address

from per_email_addresses

where EMAIL_ADDRESS_ID=(select CAND_EMAIL_ID

from IRC_CANDIDATES

where CANDIDATE_NUMBER=1123028

)

But, when I try to "transform" in update command (query above), I have this error:

ORA-00903: invalid table name

No more information about this error.

Just in case, I launch my queries from: My Clients Groups>Dashboard>Catalog>New DataModel>New SQL Query

I believed that have not enough rights to launch update command but it's not consistent with this error message.

Thanks for help

P.S: @Lothar Armbrüster , It seems to be a table here https://docs.oracle.com/en/cloud/saas/human-resources/22d/oedmh/peremailaddresses-3544.html#peremailaddresses-3544