Re^2: ... something in the environment?

in reply to Re: ... something in the environment?
in thread ... something in the environment?

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.

Comment on Re^2: ... something in the environment?

Replies are listed 'Best First'.
Re^3: ... something in the environment? by Veltro (Hermit) on Feb 28, 2020 at 16:02 UTC
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.	[reply]

Replies are listed 'Best First'.

Re^3: ... something in the environment?
by Veltro (Hermit) on Feb 28, 2020 at 16:02 UTC

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.

[reply]

In Section Seekers of Perl Wisdom