Re: Where did 0 go?

  • From: neil kodner <nkodner@xxxxxxxxx>
  • To: eugene.pipko@xxxxxxxxxxxx, oracle-l List <oracle-l@xxxxxxxxxxxxx>
  • 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);
                ……
                ……
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.

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2009