Urgent!, update oracle table

[Robert_73]

Hi list,
I can select the data and trim it using the select statements

select ltrim(url,'"') from docpar
select datetime,substr(url,1,32) url,company,username from docpar

but I want to update it, how do I update?. I tried


update docpar
set url = replace(url,'"', ltrim(url,'"'))

update docpar
set url = substr(url,1,32)
Both does not work.

[Yogeeraj_1]

hi robert,
-
to make thing easier, can you please:
a. post the error you are getting
b. confirm whether you are the owner of the table being updated.
-
revert
-
regards
Yogeeraj

[Hari Kumar]

Can you please post the Errors ??
These are the general errors when Object locked--------------

"ORA-00054: resource busy and acquire with NOWAIT specified"
Occurs when you attempt to lock NOWAIT and the resource is already locked.
"ORA-00060 deadlock detected while waiting for resource"

The rule is that primary keys must be preserved during the transaction.
You may be referencing a Foriegn and check the Primary key and the constraints of the
table.