This content has been marked as final. Show 2 replies
I don't think the format trigger is a good "place" to implement this code :
A format trigger can fire multiple times for a given object, whenever Reports Builder attempts to format the object. Consider the case where Reports Builder starts to format the object at the bottom of a page. If the object does not fit on the page, Reports Builder stops formatting and reformats on the following page. In this case, the format trigger will fire twice. It is therefore not advisable to do any kind of "persistence" operation, such as logging, in this trigger.
First you create one formula column then go to plsql editor and paste your code in plsql editor. it will work...