Re: Where did 0 go?
From: neil kodner <nkodner_at_gmail.com>
Date: Wed, 23 Sep 2009 17:16:05 -0400
Message-Id: <F6E3BDB0-4835-43A0-B091-97916092CE38_at_gmail.com>
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:
Date: Wed, 23 Sep 2009 17:16:05 -0400
Message-Id: <F6E3BDB0-4835-43A0-B091-97916092CE38_at_gmail.com>
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);
> ……
> ……
> 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 - 16:16:05 CDT