How to write to job log from Oracle Report Builder 10.1.2.3.0
It appears that the author used the SRW
built-in package and its USER_EXIT
procedure, i.e.
srw.user_exit('G_Catgeory')
(by the way, looks like category was misspelled. Maybe it should have been G_Category
).
How to find it? Save the report as a JSP file. Then open it in any text editor (such as Notepad) and search for the above terms. Once you find where it is, you should be able to locate & fix it in Reports Builder.
As of the message you'd want to print: use the SRW package (again), but this time the MESSAGE procedure, e.g.
srw.message(1, 'This is a message');
For more info have a look at Reports Online Help system.