Aka, "Where did all my changes go, and why does this trigger's creation only work in sqlplus?"

Roland Bouman's blog: Oracle SQL Developer 1.1 Supports MySQL:
Sorry, that was a PEBKAC (Problem Exists Between User And Chair)

All I needed to do was turn on "auto commit" in SQL Developer.
Tools -> Preferences
Click next to Database,
Select Worksheet Parameters
Click checkbox to mark "Autocommit in SQL Worksheet"
Close SQL Developer and re-launch.

Problem solved.


More on how autocommit works in Oracle from an Ask Tom segment here (from 2000! though last updated this month).

I've always used SQuirreL-SQL when using Oracle to this point, and this hasn't been an issue. Very non-SQL Query Analyzer. Old habits die hardest, I guess.

Labels: , ,