How to write to job log from Oracle Report Builder 10.1.2.3.0 How to write to job log from Oracle Report Builder 10.1.2.3.0 oracle oracle

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.