CODEWITHSUNDEEP
oracle-databaseoraclereports
alexherm
alexherm

Reputation: 1362

How to write to job log from Oracle Report Builder 10.1.2.3.0

I am touching an old report using Oracle Report Builder 10.1.2.3.0. I believe I am having trouble with some function within the report, but the error is very generic and does not point to a specific object.

    MSG-00002: Init failed
    REP-1416: '': User exit 'G_Catgeory'. .
    REP-0069: Internal error
    REP-57054: In-process job terminated:Terminated with error: 
    REP-1416: MSG-00002: Init failed
    REP-1416: '': User exit 'G_Catgeory'. .

Is there a way to write to the concurrent request log file from an RDF (Report Builder data definition)?

I have tried using DBMS_OUTPUT commands within a RDF function but the object will not compile:

    'DBMS_OUTPUT is not a procedure or is undefined.'

Any tips on how to debug these old school reports is appreciated.

Upvotes: 3

Views: 1790

Answers (1)

Littlefoot
Littlefoot

Reputation: 142778

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.

Upvotes: 4

Related Questions