Forum: Ruby ODBC Oracle error for indexes() call "Invalid string or buff

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
Chris McMahon (Guest)
on 2007-01-16 20:00
(Received via mailing list)
I have a Ruby program talking to MS ODBC Driver for Oracle on WinXP.
The script makes successful calls to columns() function, but for a call
to indexes(), returns

ora_index_p4.rb:185:in `indexes': S1090 (0) [Microsoft][ODBC driver for
Oracle]Invalid string or buffer length (ODBC::Error)

The code is something like:
#######################################
require 'odbc'
get_new = @conn.run("select table_name from dba_tables where owner =
'#{new_db_name}'")
tables = get_new.fetch_all

tables.each do |table|
  columns = @conn.columns(table.to_s)
  indexes = @conn.indexes(table.to_s")
end
##########################################


The strange part is that this call was working on this host last week,
so it's as if something has changed on the host.  I did in fact remove
and re-install Ruby 185-21 Windows one-click installer, but the
behavior remains the same.

Any suggestions would be welcome.
This topic is locked and can not be replied to.