its a slightly obscure combination of parameters, but when I set
ora_ph_type=96, my dbms_output from Oracle stored procedures disappeared.
Turns out this setting affected the parameter binding in sub dbms_output_get
in Oracle.pm, so that the return status from dbms_output.get_line is '0
' instead of '0', and the fetching terminates immediately. The actual
output lines are also blank padded to 400 characters.
Would it be a good idea to hardwire the parameter type in the parameter
binding in this routine, to prevent any global settings from upsetting it?
eg: lines 534-535 become:
$sth->bind_param_inout(':l', \$line, 400, { ora_type => 1 });
$sth->bind_param_inout(':s', \$status, 20, { ora_type => 1 });
Michael Fox
Australia Post is committed to providing our customers with excellent service. If we
can assist you in any way please either telephone 13 13 18 or visit our website
www.auspost.com.au.
CAUTION
This e-mail and any files transmitted with it are privileged and confidential
information intended for the use of the addressee. The confidentiality and/or
privilege in this e-mail is not waived, lost or destroyed if it has been transmitted
to you in error. If you have received this e-mail in error you must (a) not
disseminate, copy or take any action in reliance on it; (b) please notify Australia
Post immediately by return e-mail to the sender; and (c) please delete the original
e-mail.
