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.