Oracle SQL Developer Problem

Nemesis379 · 12 Dec 2012 at 14:56

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!

mp3duck · 12 Dec 2012 at 15:35

is the vehicle ID used as a foreign key in another table?

Nemesis379 · 12 Dec 2012 at 15:41

Nemesis379 · 12 Dec 2012 at 16:15

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...

Nemesis379 · 12 Dec 2012 at 18:05

Anyone got any ideas?

da_mic_1530 · 12 Dec 2012 at 18:19

Any locks on the table?

Nemesis379 · 12 Dec 2012 at 18:34

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.

GravyMonster · 13 Dec 2012 at 09:11

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.