Oracle update not properly ended.

[Wilsond3010]

Can anyone spot what is wrong with this bit of code.

update license_list
set license_list.license_type = productmap.license_type
from license_list, productmap
where product_name = tivoli_product_name
and netc_version = tivoli_version

I keep getting sql command not properly ended.

 

[karluk]

I think you are combining features of a select statement with your update, specifically your "from" clause. You have already specified which table you are updating, so the from clause shouldn't be part of your update statement.

Try using a subquery instead. Something like the following should work, assuming tivoli_product_name and tivoli_version form a unique key for your productmap table.

update license_list
set license_list.license_type =
(select productmap.license_type
from productmap
where product_name = tivoli_product_name
and netc_version = tivoli_version)