Greetings!!
We are using ActivePerl 5.6.1 (Build 635) & DBI (1.27) Proxy running on
MS Windows to connect
to SQL Server from Solaris.
Even though the following SQL query succeeds in MS SQL Query Analyzer,
Via DBI Proxy the
following query returns an error:
my $sth = $dbh->prepare( "select lkpver.text_string as
version,lkpst.text_string as
status from release_target rt, lookup lkpst, lookup lkpver where
rt.product_issue_id
= $bfn and lkpst.lookup_category_name =
'm2_release_target_status' and lkpst.code_int
= rt.status_lkp and lkpver.lookup_category_name = 'm2_fix_in'
and lkpver.code_int =
rt.fix_in_version_lkp");
$sth->execute($bfn);
The Error Message:
DBD::Proxy::st execute failed: Server returned error: Failed to
execute method
CallMethod: Can't bind unknown placeholder '1' at
E:/netperl/site/lib/DBI/ProxyServer.pm line 313.
exec: DBI::st=HASH(0x41f870)
Any Pointers, Help to resolve this issue would be very much appreciated.
Thanks,
-Murali