I am getting the below error while running the report
REP-2103 Column 'CS_Achived_tot' : PL/SQL formula returned invalid value or no value
Could you please help me ... Thanks in Advance
Dear Friend ,
So it may be because of data that you are returning from format trigger. Please use following code to debug the error.
SRW.MESSAGE(1,'A:'||ValueThatYouWhantToReturn);--If value is null or other than the type that you specified in Return statement, It will show error.
Ahame Rafeeque Cherkala
I have used the below code in the formula column
function CF_Achived_totFormula return Number is
exception when others
no data was there in the attribute4 feild and it was varchar2 data type
One thing You can return only Number data item in your becuse you used return Number is key word if you want to return VARCHAR2 replace NUMBER with VARCHAR2. And one thing more you can't use return null
Edited by: Ahamed Rafeeque on Feb 12, 2013 4:28 AM