I have developed a program suite on Windows that talks to a Teradata over ODBC and works fine. I need to port it to DBD::Teradata on an AIX box, as ODBC is not installed. I have built a local perl (5.14) (cc_r is missing, so I had to compile a copy with gcc) and I have installed DBI ver 1.6.16 and DBD::Teradata version 12.001 (from Prescient)
I can execute a connect correctly. However, when I try and run a simple test program that executes a stored procedure, the $dbh->execute fails. The core of the test program is: $refStr = "call crchampsview.FD622_Determine_Date_Range_SP( '2011-04-01' )"; $sth = $dbh->prepare($refStr); $sth->execute; $row = $sth->fetchrow_hashref; $sth->finish; print Dumper($row); Called from ODBC the results are: $VAR1 = { 'Beginning_Date' => '2011-03-27', 'Ending_Date' => '2011-04-02', '\'FD622\'' => 'FD622' }; But called through the DBD::Teradata, the program fails as: DBD::Teradata::st execute failed: Failure 7968: FD622_Determine_Date_Range_SP:The recipient of the result set does not support dynamic result sets. on Statement 0. at ./trPDateSPTest.pl line 61. $VAR1 = { 'Input_Date' => '2011-04-01' }; Explanations and/or work-arounds/corrections will be most gratefully received. Thanx Jeff Tate CHAMPS Project Office DW/TCO Manager (415) 606 7621 (cell) (925) 887 6825 (eFax) <mailto:tat...@michigan.gov> tat...@michigan.gov (scheduling)