469,929 Members | 1,379 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,929 developers. It's quick & easy.

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 5755
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
By using this site, you agree to our Privacy Policy and Terms of Use.