Re: Where did 0 go?
Date: Wed, 23 Sep 2009 17:16:05 -0400
if table.colum%type is in fact a varchar2 like you say then something inside of func_t is likely treating it as a number. can we see the relevant parts of funct_t?
On Sep 23, 2009, at 4:55 PM, Eugene Pipko wrote:
> 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);
> Function returns 057, however when it gets assigned to vDept it
> turns into 57.
> How do I preserver zero?
> Eugene Pipko
> P Please consider the environment before printing this e-mail.