From: Chris McMahon <christopher.mcmahon@...>
Date: 2007-01-17T03:00:11+09:00
Subject: ODBC Oracle error for indexes() call "Invalid string or buffer length"


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.