471,050 Members | 1,366 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,050 software developers and data experts.

Oracle Reports 6 recompilation

Hi,

How do dependencies work with Oracle reports?

I have a set of developers creating reports in Report Builder 6 w/
Oracle 8i and every time the stored packages change that the report
uses, I am asked to recompile the reports. I guess what I am trying
to understand is when you run the report (from the .rep file) why does
it fail if the stored package has been changed (assuming the stored
package is once again valid).

Any help would be greatly appreciated.
Jul 19 '05 #1
3 5803
FuzzyBear wrote:
Hi,

How do dependencies work with Oracle reports?

I have a set of developers creating reports in Report Builder 6 w/
Oracle 8i and every time the stored packages change that the report
uses, I am asked to recompile the reports. I guess what I am trying
to understand is when you run the report (from the .rep file) why does
it fail if the stored package has been changed (assuming the stored
package is once again valid).

There is an initSID.ora parameter, whose exact name escapes me.
The name includes "SIGNATURE" string.
When properly used it allows forms to continue to use the package
when the body has change & while the calling argument list remains
constant.

Rhetorical question--->
If/when Forms detects a package which indicates
the package changed since when the Form was compiled,
how can the Form be SURE that the form can still
successfully use the package?
To be safe the form refuses to run until it get
successfully (re)compiled against the "new" package.

Jul 19 '05 #2
FuzzyBear wrote:
Hi,

How do dependencies work with Oracle reports?

I have a set of developers creating reports in Report Builder 6 w/
Oracle 8i and every time the stored packages change that the report
uses, I am asked to recompile the reports. I guess what I am trying
to understand is when you run the report (from the .rep file) why does
it fail if the stored package has been changed (assuming the stored
package is once again valid).

Any help would be greatly appreciated.

FOUND IT.
You want REMOTE_DEPENDENCIES_MODE=SIGNATURE

Jul 19 '05 #3
"Ana C. Dent" <an*******@hotmail.com> wrote in message news:<22T2b.65839$kP.64113@fed1read03>...
FuzzyBear wrote:
Hi,

How do dependencies work with Oracle reports?

I have a set of developers creating reports in Report Builder 6 w/
Oracle 8i and every time the stored packages change that the report
uses, I am asked to recompile the reports. I guess what I am trying
to understand is when you run the report (from the .rep file) why does
it fail if the stored package has been changed (assuming the stored
package is once again valid).

Any help would be greatly appreciated.

FOUND IT.
You want REMOTE_DEPENDENCIES_MODE=SIGNATURE


Thanks for the reply!

I checked and we are using this and apparently this did help with the
original problem of recompiling packages causing forms to fail. The
two options are TimeStamp and Signature with Signature being the more
useful of two. This however still leaves me without a solution to the
reports not working again. I am going to look more into this today and
put up a test case.
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by kristoff plasun | last post: by
reply views Thread by Rohit Dhawan | last post: by
1 post views Thread by rishka | last post: by
133 posts views Thread by jonathan | last post: by
3 posts views Thread by FuzzyBear | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.