On Oct 17, 3:26 pm, Jeremy Evans <[email protected]> wrote: > On Oct 17, 2:40 pm, Will Gorman <[email protected]> wrote: > > Sequel::DatabaseError: NativeException: java.sql.SQLException: ORA-02287: > > sequence number not allowed here
This is due to changes in the Oracle adapter, but not in the place I expected. The issue is Sequel wraps your SQL in a subselect because you used first, which Oracle does not like. Sequel probably shouldn't be forcing a subselect for custom SQL unless you specifically use Dataset#limit. I forked your gist and fixed things so they should work, see https://gist.github.com/1294055. This makes Sequel use the correct sequence before inserting the record, and not submit another query to get identical information after the insert. I'll be committing a change to the shared oracle adapter to fix it so your old code should still work. If you haven't open sourced your plugin, I recommend doing so, as I think other users could benefit from it. Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
