Done. Thanks!
Tim.
On Tue, Nov 26, 2002 at 11:13:58AM +1100, Fox, Michael wrote:
>
> 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.
