I have a report - X; it have a reference to a DB package ( DB package is reference in the report package specification level as well i.e i declared a table type of the table type declared in the db package)
Do i have re-compile the report all the time when ever i deliver a new version of the db package ( with the change in DB package specification, eg: adding new function not related to the report)
report version is 10g
i call using web.show_document
the error i see in report job queue is ""cancel upon user request"
Adding i have more question....
if i attach a pll to the report (i do not compile pll).. and later if add a new procedure in pll .. should i reattach the pll to the report? or since it is a pll it will be taken care automatically..
>report version is 10g
That is not really a version, but a product. Check the exact version and make sure you have the latest patch installed.
On the other hand, it looks like it is just a long running report that is getting cancelled.
You started this thread by asking if you need to recompile. Does the report run after a recompile? If so, just do that then.