When using Rails on top of an Oracle database, you use the oracle enhanced activerecord adapter. This adapter (or Rails) has one weird side-effect: there is no way to avoid using a sequence when inserting a new record.
But, in this comment, Raimonds Simanovskis hints at the solution.
In an initializer you write:
# a small patch as [...]
PL/SQL package: lessons learned
Working with Oracle Spatial a lot, I found a great source of information in the Spatial DB Advisor, which besides a lot of interesting articles, also offers his source-code and PL/SQL packages for free. The site is not very user-friendly (trouble of seeing the threes through the wood), as finding the free [...]
I am now working in Ruby on Rails for about a month. I have done a few smaller things before, investigating, trying out; but now I am really building a full application site in Rails! It feels great :)
But of course, just starting out in such a new environment, both ruby and rails, I encountered [...]
At my new job I am back to administering Oracle. The last time I had to do any dba-job, they were still using Oracle 7 :) At my current job, the IT-department can be summed up in one word: me! So, now i have to do everything again.
So today, i was trying to get a [...]
We had more than a few troubles migrating to Oracle 10, in our production environment. We are using a clustered server, with 3 nodes, so it should be blindingly fast.
I’ll sum up our biggest issues (we had) :
Sequences : we used a sequence to make sure the messages we send, can be ordered. Somehow our [...]
