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.