Where did 0 go?
From: Eugene Pipko <eugene.pipko_at_unionbay.com>
Date: Wed, 23 Sep 2009 13:55:52 -0700
Message-ID: <34DB87F47199374280ADFD2968CDBCFA88143B441D_at_MAIL01KT.seattlepacificindustries.com>
Hi all,
I have a potentially silly question and need your help.
End;
Date: Wed, 23 Sep 2009 13:55:52 -0700
Message-ID: <34DB87F47199374280ADFD2968CDBCFA88143B441D_at_MAIL01KT.seattlepacificindustries.com>
Hi all,
I have a potentially silly question and need your help.
Procedure abc is
vDept table.column%type; <====== varchar2(80) Begin ........ vDept := func_t(par1, par2);
......
......
End;
Function returns 057, however when it gets assigned to vDept it turns into 57. How do I preserver zero?
Thanks,
Regards,
Eugene Pipko
P Please consider the environment before printing this e-mail.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 23 2009 - 15:55:52 CDT