SQL & PL/SQL

Hi,

I need to do something like this:

update my_table set (prelucrat, err) = (select case
                                                         when r.id is not null then
                                                           ('D', null)
                                                         else
                                                           ('N', 'Nu exista persoana cu marca '||r.marca)
                                                       )
where marca = r.marca and ctiserver = r.ctiserver

But I got a "missing right paranthesis" error.

"r" is a cursor variable, so this update is nested into a "for r in (...) loop".

What I'm doing wrong? Is it possible to update two columns at once and use case in that select?

Thank you.