Asp Forum
Home
|
Login
|
Register
|
Search
Forums
>
comp.lang.ruby
DBI:ODBC-Question
Oliver Osterholz
11/20/2003 11:08:00 AM
Hi, (here my third trial, sorry)
I'm trying to execute a prepared statement several times:
dbh=DBI.connect("dbi:ODBC:TESTDB", "test", "test")
sth=dbh.prepare("select * from z_da where entitaet_c = ?")
sth.execute("egpa ")
sth.execute("kbpa ")
On the second execute i get the Message:
DBI::DatabaseError: S1010 (0) [Oracle][ODBC]Function sequence error.
D:/Programme/ruby/lib/ruby/site_ruby/1.8/DBD/ODBC/ODBC.rb:204:in `execute'
D:/Programme/ruby/lib/ruby/site_ruby/1.8/dbi/dbi.rb:743:in `execute'
Does anybody know what's wrong here? I guess I miss something important.
Another problem is that since the db-field entitaet_c is defined as char(20) I have to write
sth.execute("egpa ") to get results. I didn't expect that since this works fine:
dbh.execute("select * from z_da where entitaet_c='egpa'")
thank you for your help
Oliver
______________________________________________________________________________
Horoskop, Comics, VIPs, Wetter, Sport und Lotto im WEB.DE Screensaver1.2
Kostenlos downloaden:
http://screensaver.web.de/...
Servizio di avviso nuovi messaggi
Ricevi direttamente nella tua mail i nuovi messaggi per
DBI:ODBC-Question
Inserendo la tua e-mail nella casella sotto, riceverai un avviso tramite posta elettronica ogni volta che il motore di ricerca troverà un nuovo messaggio per te
Il servizio è completamente GRATUITO!
x
Login to ForumsZone
Login with Google
Login with E-Mail & Password