topic Re: Urgent!, update oracle table in Operating System - HP-UX

Urgent!, update oracle table

Robert_73 — Fri, 10 Oct 2003 12:17:03 GMT

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.

Re: Urgent!, update oracle table

Yogeeraj_1 — Fri, 10 Oct 2003 23:21:41 GMT

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

Re: Urgent!, update oracle table

Hari Kumar — Sat, 11 Oct 2003 02:52:09 GMT

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.