Archives of the TeradataForum
Message Posted: Fri, 13 Jun 2003 @ 18:43:26 GMT
| Subj: || || Re: Perl and DBD::Teradata 1.13 |
| From: || || Geoffrey Rommel |
| ||While writing a Perl script which accesses locally a Teradata database via DBI and DBD::Teradata 1.13, I encountered some unexpected
errors related to a premature error while fetching data from a SELECT statement. The same SELECT statement works quite easily in
| ||In the middle of a fetching loop, it stops complaining|
ERROR 3119: Continue request submitted but no response to return.
I believe the problem is that you have two request handles open ($stmt and $update). According to the documentation for
DBD::Teradata, this is invalid; you must open two connections (two sessions) and have only one request open at a time in each one. (I quote:
"... you can't execute new requests on a database handle that has a currently open and active request on it. Either finish() the current
request first, or use an additional connection to issue the new request.") Good luck!