On Jan 18, 2:17 pm, Glen <[email protected]> wrote: > So, I'm experiencing what I would describe as inconsistent behavior > from the oracle adapter. > > I can create a Sequel::Oracle::Database object without issue. > However, when I try executing a raw query with .run I get nil: > > oracle.run(query + "'#{user}'") > > > nil > > Oddly, at least to me, when I create a dataset with the same query I > can dig to get the data: > > oracle[query + "'#{user}'"].each do |row| > row.each do |r| > p r > end > end > > > [:gorirol_role, "EMPLOYEE"] > > [:gorirol_role, "STUDENT"] > > I would expect run to return something useful either an error or a > DATASET object maybe. Am I missing something? > > -Glen
http://sequel.rubyforge.org/rdoc/classes/Sequel/Database.html#method-i-run >From the documentation for Database#run "Runs the supplied SQL statement string on the database server. Returns nil" Use the elegant Sequel DSL to construct queries rather than constructing SQL strings. -- 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.
