[sqr-users] Why no decimal in Insert ?

["Ashish Bhatt" <ashish_bhatt@hotmail.com>]

Hi SQR Gurus,

I hope you are doing fine today.

I have below sqr code for insert into ps_DEDUCTION_BAL table.

It does not show decimal in the column DED_YTD when I select the data of 
ps_DEDUCTION_BAL table.

Below show statement shows the value of #DED_YTD with decimal.

I tried putting to_number for DED_YTD. But no luck.


   let #DED_YTD = $DED_YTD

show '#DED_YTD: ' #DED_YTD

begin-SQL on-error=WARN

Insert into ps_DEDUCTION_BAL
       (Emplid,
        COMPANY,
        BALANCE_ID,
        BALANCE_YEAR,
        BALANCE_QTR,
        BALANCE_PERIOD,
        BENEFIT_RCD_NBR,
        PLAN_TYPE,
        BENEFIT_PLAN,
         DEDCD,
         DED_CLASS,
         DED_YTD,
         DED_QTD,
         DED_MTD)
Values ($oEmplid,
        $oCOMPANY,
         $BALANCE_ID,
         $BALANCE_YEAR,
         $BALANCE_QTR,
         $BALANCE_PERIOD,
         $BENEFIT_RCD_NBR,
         $oPLAN_TYPE,
         nvl($oBENEFIT_PLAN,' '),
         $oDEDCD,
         $oDED_CLASS,
         #DED_YTD,
         #DED_QTD,
         #DED_MTD)
end-sql

Please reply.

Thanks in advance.

Have a nice day and great week.

Regards.

Ashish Bhatt.

_________________________________________________________________
Download Norah Jones, Eminem and more! http://www.msn.com.sg/ringtones/ at 
only S$36 including GST

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users