DB2 error: "Can't bind unknown parameter marker ':p4'"

Error: Can't bind unknown parameter marker ':p4' My code:

my $returnValue;
$sth = $self->GetDatabase()->prepare( "CALL mySchema.myStoredProcedure
+(?,?,?)" );
$sth->bind_param(1,$p1);
$sth->bind_param(2,$p2);
$sth->bind_param(3,0);
$sth->bind_param_inout(4,\$returnValue,20);
$sth->execute();
$sth->finish();
[download]

I'm not sure what the problem could be... everything (AFAIK) seems right. Anyone have any ideas?

Comment on DB2 error: "Can't bind unknown parameter marker ':p4'" Select or Download Code
Re: DB2 error: "Can't bind unknown parameter marker ':p4'" by Anonymous Monk on Jan 18, 2013 at 04:02 UTC
I'm not sure what the problem could be... everything (AFAIK) seems right. Anyone have any ideas? Sure you are :) Can't bind unknown parameter marker is a very specific error message, and since :p4 doesn't occur in the cod you posted, it must occur in the stored procedure	[reply]
Re^2: DB2 error: "Can't bind unknown parameter marker ':p4'" by shanknbake (Initiate) on Jan 18, 2013 at 20:14 UTC
I'm thinking that the error is in the way that I'm calling the stored procedure... does that look okay?	[reply]
Re^3: DB2 error: "Can't bind unknown parameter marker ':p4'" by shanknbake (Initiate) on Jan 18, 2013 at 23:16 UTC
The stored procedure looks to be working fine - I tested it manually using the Data Studio tool. So it must be something funky with the way that I'm calling it...	[reply]
Re^4: DB2 error: "Can't bind unknown parameter marker ':p4'" by Anonymous Monk on Jan 19, 2013 at 08:31 UTC
Re: DB2 error: "Can't bind unknown parameter marker ':p4'" by runrig (Abbot) on Jan 19, 2013 at 17:15 UTC
AnonyMonk above has it right...you have 3 ?'s, and 4 binds. If you are trying to get the return value from the stored procedure, try using the `$sth->{db2_call_return}` attribute.	[reply] [d/l]
Re^2: DB2 error: "Can't bind unknown parameter marker ':p4'" by shanknbake (Initiate) on Jan 22, 2013 at 02:33 UTC
$sth->{db2_call_return}; is EXACTLY the thing I've been missing!!! Thank you so much! I've not ONCE seen an example where someone uses that! TYVM!	[reply]


Welcome to the Monastery
	PerlMonks

DB2 error: "Can't bind unknown parameter marker ':p4'"

The best material for plates (tableware) is: