Oracle Database Discussions

Hi Guru

I am facing Divide Problem . It get the following error - ORA-1476.

Can anyone suggest How to solve this problem : Here I am giving below my validate Query

declare
x number;
begin

IF :UOM='PCS' then
:QTYPCS:=:QTY;
:QTYKGS:=(nvl(:REPT_LGTH,1)/1000) *
(nvl(:DESIG_WIDTH,1)/1000) *
(nvl(:TOTAL_GSM,1)/1000)*nvl(:QTY,0);


---DECODE( SUM( packet_count ), 0, NULL )
:MTRS:= NVL(:QTYPCS,0)*NVL(:REPT_LGTH,1)/
(NVL(:NO_COILS,0) * 1000);

:QTYSQMTR:= NVL(:QTYPCS,0)*NVL(:REPT_LGTH,1)/
(NVL(:NO_COILS,0) * 1000)*(NVL(:INPUT_WEBWIDTH,0)/1000);
----------------------------------------------------------------------------------------
elsif :UOM='KGS' then
:QTYKGS:=:QTY;

:QTYPCS:= NVL(:QTYKGS,0)* 1000 /
NVL(:TOTAL_GSM,0)*1000 /
NVL(:WEB_WIDTH,0) * NVL(:NO_COILS,0) * 1000 / NVL(:REPT_LGTH,0);

:QTYSQMTR:= NVL(:QTYKGS,0)* 1000 / NVL(:TOTAL_GSM,0);

:MTRS:= NVL(:QTYKGS,0)* 1000 /
NVL(:TOTAL_GSM,0)*1000 /
NVL(:WEB_WIDTH,0);
------------------------------------------------------------------------

elsif :UOM='SQM' then

:QTYSQMTR:=:QTY;
:MTRS:= (NVL(:QTYSQMTR,0)/ NVL(:INPUT_WEBWIDTH,0)) *1000;
:QTYPCS:=(NVL(:MTRS,0) /NVL(:REPT_LGTH,0)) * (NVL(:NO_COILS,0) * 1000);
:QTYKGS:= (NVL(:QTY,0) * NVL(:TOTAL_GSM,0))/1000;

END IF;
----Printing Qty
x:=(nvl(:subgsm,0) * nvl(:qty,0)) / nvl(:total_gsm,0);
:print_qtykg:=(x*15/100)+x;
----Foil Qty
:foil_Qty:=(nvl(:Lamigsm1,0) * nvl(:Print_qtykg,0)) / nvl(:Subgsm,0);
----PE Qty
:PE_Qty:=(nvl(:Lamigsm2,0) * nvl(:Print_qtykg,0)) / nvl(:Subgsm,0);


raise form_trigger_failure;

end;


sandy