# DBI:ODBC-Question

**URL:** <https://rubytalk.org/t/dbi-odbc-question/8954>\
**Category:** ruby-talk\
**Created:** [20 November 2003 09:45 UTC](https://rubytalk.org/t/dbi-odbc-question/8954 "2003-11-20T09:45:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Oliver\_Osterholz](https://avatars.discourse-cdn.com/v4/letter/o/e0b2c6/32.png) [@Oliver\_Osterholz](https://rubytalk.org/u/Oliver_Osterholz)\
**Post date:** [20 November 2003 09:45 UTC](https://rubytalk.org/t/dbi-odbc-question/8954/1 "2003-11-20T09:45:00Z")

</div>

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 ")

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

> **···**
>
> * * *
> 
> [WEB.DE](http://WEB.DE) FreeMail wird 5 Jahre jung! Feiern Sie mit uns und  
> nutzen Sie die neuen Funktionen [**http://f.web.de/features/?mc=021130**](http://f.web.de/features/?mc=021130)
