Home » SQL & PL/SQL » SQL & PL/SQL » Update row
Update row [message #18346] Tue, 29 January 2002 01:10 Go to next message
PMB
Messages: 2
Registered: January 2002
Junior Member
I'm using this statemant to update rows:
UPDATE lk_mes p SET VALUE(p) =
(SELECT VALUE(q) FROM lk_mes@medic.algarve q
WHERE q.cod_mes = p.cod_mes)
WHERE p.cod_mes = 199801
but oracle rejects with message of wrong name column. What is wrong?
Re: Update row [message #18348 is a reply to message #18346] Tue, 29 January 2002 03:28 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
@medic.algarve
is this database link?

are u able to execute this stmt from sqlplus?

SELECT VALUE(q) FROM lk_mes@medic.algarve ;
Re: Update row [message #18351 is a reply to message #18346] Tue, 29 January 2002 04:35 Go to previous message
PMB
Messages: 2
Registered: January 2002
Junior Member
Hello,

@medic.algarve - yes, it is database link.

No, I don't able to execute the stmt because of "VALUE(q)".

Note: This example it is base on documentation Oracle
Previous Topic: PL/SQL Exception Handling
Next Topic: Query error frustrating beginner
Goto Forum:
  


Current Time: Sat Apr 04 21:38:02 CDT 2020