hi,
my requirement is like this - i need to execute couple of queries in different databases like, Oracle, DB2 and Teradata and i need to execute bunch of scripts based on the query results.
today, i'm trying to execute simple queries against oracle database. but, i'm getting the below error again and again when i try to execute 'describe tabs' query.
c:/ruby/lib/ruby/site_ruby/1.8/oci8.rb:557:in `execute': ORA-00900: invalid SQL statement (OCIError)
from c:/ruby/lib/ruby/site_ruby/1.8/oci8.rb:557:in `exec'
from c:/ruby/lib/ruby/site_ruby/1.8/oci8.rb:109:in `do_ocicall'
from c:/ruby/lib/ruby/site_ruby/1.8/oci8.rb:557:in `exec'
from c:/ruby/lib/ruby/site_ruby/1.8/oci8.rb:178:in `exec'
But, i'm able to execute ('select * from all_users where username = :1', 'System')
i got the above query from the web.
Any clues?
Regards,
Nivetha.
Email - [EMAIL PROTECTED]
Mobile - (0) 98807 17518
_______________________________________________ Wtr-general mailing list [email protected] http://rubyforge.org/mailman/listinfo/wtr-general
