Help!
I am getting the following error code:
C:\Temp\Kaiser\kaisersubscribersoapclient.pl: Failed: Can't rebind
placeholder 8 at c:/Perl/lib/Subscriber.pm line 795, <DATA> line 164.
with the following code:
my $substh = $dbh -> prepare(
"INSERT INTO ktc_subscriptions ( subscription_id, contact_id,
org_id, subscription_item_id, subscription_status_id,
create_date, source_id, created_by_user_id) VALUES ( ?, ?, ?, ?,
?, ?, ?, ?)" )
or error_handler ("Register Subscription Insert prepare failed,
$DBI::err ($DBI::errstr)", __LINE__);
my $subs = $substh -> execute( "$sub->{subscription_id}",
"$sub->{contact_id}", "$sub->{organization_id}",
"$sub->{subscription_item_id}",
"$sub->{subscription_status_id}", "$sub->{create_date}",
"$sub->{registration_source}","$sub->{created_by_user_id}" )
or error_handler ("INSERT Subscription information failed, $DBI::err
($DBI::errstr)", __LINE__);
I am getting the rebind error, but not the error_handler error call, so it
appears that somewhere below my code the error is being thrown and the
program exiting before my error handler gets a chance to run.
I tested this code last week and it was working. It is possible the
underlying database changed in the intervening time; however, all of the
columns still exist.
The underlying database is MS SQLServer and I am using DBI:ODBC as the
interface.
Any insights into what is causing the problem would be very appreciated.
TIA.
Bernard Golden
