Re: ... something in the environment?

[Veltro]

What does the stored procedure return in case the update or insert fails?

[chexmix]

In case of failure, the subroutine returns the nature of the failure (in $action, if I recall correctly -- I'm home sick). In this case the transaction is rolled back, too.

The program is supposed to print the failure to an error log and quit.

[Veltro]

Ok, this is something you may need to verify. The reason why I asked is to be sure that the return values are valid SQL_INTEGER and SQL_VARCHAR. Usually the program writes back the values that it received by the bind instructions which are in this case undef. I'm not sure but I think that when the stored proc doesn't set them then undefs are returned and those may be invalid values for the type specified.