This content has been marked as final. Show 5 replies
you should return a value from formatt trigger as below and return type should be mathingh with the return statemen of declaration.
Ahamed Rafeeque Cherkala
i have done the same thing but it showing error..
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