Hi,
The problem described below does not apply when using DBD::SAP_DB
instead of DBD::ODBC. The second test script does not eat Temp Space
when ODBC is replaced with SAP_DB!
Question to SAP developers:
Does DBD::SAP_DB use the SAP ODBC library on Linux?
Question to DBD::ODBC developers:
Are destruction of statement handlers handled differently
when a select does not return any result set?
# schoen
----- Original Message -----
From: "schoen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 24, 2002 10:44 AM
Subject: Error -904 when selecting without result
> Hi,
>
> I have a application that sometimes get error -904.
> It does a lot of selects which returns no result set
> and I think that is the reason.
>
> My system is an Intel box with Redhat 7.2, SAP DB 7.3.0.18, DBI 1.201,
> DBD::ODBC 0.32.
>
> This script does not eat Temp Space (select return one row):
>
> #!/usr/bin/perl
> use DBI;
> $dbh=DBI->connect('dbi:ODBC:TST', 'TEST', 'TEST');
> $dbh->do("create table TESTA (ID INTEGER NOT NULL, PRIMARY KEY(ID))");
> $dbh->do("insert into TESTA (ID) VALUES (1)");
> while (1)
> {
> $x=$dbh->selectall_arrayref("select ID from TESTA where ID=1");
> }
>
> This scipt eats Temp Space (the select returns no rows):
>
> #!/usr/bin/perl
> use DBI;
> $dbh=DBI->connect('dbi:ODBC:TST', 'TEST', 'TEST');
> $dbh->do("create table TESTA (ID INTEGER NOT NULL, PRIMARY KEY(ID))");
> $dbh->do("delete from TESTA where ID=1");
> while (1)
> {
> $x=$dbh->selectall_arrayref("select ID from TESTA where ID=1");
> }
>
> Is this a known bug in the SAP DB server?
>
> There are other postings to this list with people getting -904 after the
> application
> have been running for a while. Does those applications also do selects
which
> sometimes does not return any result set?
>
> # schoen
>
>
>
