Otherwise run the same query against the database through sql plus and see if it works.
-Charley
On 8/2/06, Nivetha Padmanaban <
[EMAIL PROTECTED]> wrote:
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
_______________________________________________ Wtr-general mailing list [email protected] http://rubyforge.org/mailman/listinfo/wtr-general
