| ORA-24347 in Forms9i [message #83872] |
Tue, 23 December 2003 22:40  |
Kapil Uppal
Messages: 1
Registered: December 2003
|
Junior Member |
|
|
Hello All,
I have based my datablock on the bottom stated procedure.I am getting this ORA-24347 Warning of anull column in aggregate function error.
The same query works in SQL PLus...
The package/procedure is
Create or replace Package body Contract IS
Procedure SubContractor_Grp(SUBCONTRACTOR_RESULT IN OUT ref_cur_typ4,Tender IN varchar2,Tariff In Varchar2) AS
Begin
Open SUBCONTRACTOR_RESULT for Select COST_CENTR_ID,sum(NVL(SUBCTR_COST,to_number(0))) SUBCTR_COST from
co_tendr_sumry_v where instr(Tender,TENDR_NO) > 0
and TARF_IND=decode(Tariff,'Y',tarf_ind,Tariff) group by COST_CENTR_ID;
END;
END;
Is it related to a bug and whats it workarnd???
Thanks and Regards,
Kapil Uppal
|
|
|
|
| Re: ORA-24347 in Forms9i [message #84408 is a reply to message #83872] |
Thu, 11 March 2004 06:11  |
ramana
Messages: 51
Registered: December 2000
|
Member |
|
|
Hi Kapil,
If the fields/variables/columns (Tender, TENDER_NO, Tariff) used in instr and decode functions are nullable or a chance of having null values, make sure to use NVL within INSTR and DECODE functions.
Make sure to handle NULL values for the fields/columns used in INSTR and DECODE fucntions.
Hope this helps.
Regards,
Ramana
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
