Delete oid giving problems 
Author Message
 Delete oid giving problems

Hi all,
   I am having problems deleting a record with oid. I tried
select lo_unlink(68778) from tablename
where 68778 is the oid
but it gives :
lo_unlink
-----------
        -1
        -1
(2 rows)

and when I try to delete that record by:
delete from tablename where id=1;
it goes on hang.
I want to drop this table and create a new one with the same name. But I am
stuck.
Any help would be greatly appreciated.
Thanks,
Rai
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.***.com/ .

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command



Mon, 24 Nov 2003 00:43:05 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. OID Install Problem, OID does not start through 9iAS

2. Delete oid causing problems

3. Multiple FK w/ CASCADE DELETE gives SQLERR: 274 no delete permission

4. Deleting records gives problems

5. Oid and Oid Vector

6. rdoResultSet.Delete gives no rdoErrors after a server constraint error

7. A Given HROW Referred to a Hard- or Soft-Deleted Row Error

8. DELETE or UPDATE gives an error when none registers have been modified (ADO and AS400)

9. to DELETE an empty table gives me a error..(Ado and AS400)

10. like + find = A given HROW referred to a hard- or soft-deleted row

11. HELP: A given HROW referred to a hard- or soft-deleted row

12. sql server internal error when using Delete with 2 joins gives


 
Powered by phpBB® Forum Software