DBI:ODBC-Question

Oliver Osterholz · Oliver Osterholz

<html><style>p {margin: 0px}</style><body style='font-size:9pt; font-family:Verdana; font-family: Verdana' >Hi, 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    &nbs p;            ")sth.execute("kbpa    &nbs p;            ")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 writesth.execute("egpa    &nbs p;            ") 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 helpOliver</body></html>
__________________________________________________ ____________________________ Horoskop, Comics, VIPs, Wetter, Sport und Lotto im WEB.DE Screensaver1.2 Kostenlos downloaden: <A HREF="http://screensaver.web.de/?mc=021110">http://screensaver.web.de/?mc=021110</A>

Oliver Osterholz · Oliver Osterholz

<html><style>p {margin: 0px}</style><body style='font-size:9pt; font-family:Verdana; font-family: Verdana' >Hi, 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    &nbs p;            ")sth.execute("kbpa    &nbs p;            ")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 writesth.execute("egpa    &nbs p;            ") 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 helpOliver</body></html>
__________________________________________________ ____________________________ WEB.DE FreeMail wird 5 Jahre jung! Feiern Sie mit uns und nutzen Sie die neuen Funktionen <A HREF="http://f.web.de/features/?mc=021130">http://f.web.de/features/?mc=021130</A>

Oliver Osterholz · Oliver Osterholz

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: [url]http://screensaver.web.de/?mc=021110[/url]

DBI:ODBC-Question

Thread Tools

Display