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?

Report message to a moderator

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 ;

Report message to a moderator

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

Report message to a moderator

Previous Topic: PL/SQL Exception Handling
Next Topic: Query error frustrating beginner
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 13:54:46 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.