"Dittmar, Daniel" wrote:
>
> Implizit renaming of result sets (Cursors) isn't supported yet by the Perl
> interface (similar for the Python interface).
Ah! as I suspected:)
> To have multiple result sets open at the same time, create each by the SQL
> "DECLARE name1 CURSOR FOR SELECT * FROM messages", where name1 has to be
> unique for each result set.
I wrote this hideous hack for prepare:
if ($_[1] =~ /^SELECT /i) {
my $foo = 'C'.int(rand(10000));
$_[1] =~ s/^SELECT /DECLARE $foo CURSOR FOR SELECT /i;
}
That changed the error message from:
DBD::SAP_DB::st fetchrow_array failed: Execution failed, parse again ...
To:
DBD::SAP_DB::st fetchrow_array failed: Unknown result table ...
The same thing happens if I manually declare a cursor for every query.
I'm afraid I don't know how to fix the bug, any clues would be greatly
appreciated.
> I hope this will soon be fixed.
Do you have an ETA on that?
