Oracle SQL Developer Problem

Associate
Joined
25 Dec 2009
Posts
2,042
Location
London, UK
I'm unable to delete data from a freggin table, when I run "delete from sch_vehicles" the ScriptRunner Task just runs forever, I am however able to enter data into the table and save it????

Please someone help!
 
I removed the connection, then re-added it and entered delete from sch_vehicles, and it removed them?

Oh, how I hate Oracle so much :(

Edit: Apparently I still have the problem, re-opened Oracle SQL and nothing was removed...
 
Last edited:
Honest to god, I have no idea what the hell is going on, somehow it's working fine now, one minute it doesn't want to work and the next it's working fine.
 
It's most likely trying to maintain referential integrity (ie. you've got child records and it's stopping them being orphaned) or there's a lock on the table. Do you not get any errors?

If it's intermittently working it sound like it's a locking problem.
 
Back
Top Bottom