Oracle Reports 6 recompilation

[FuzzyBear]

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.

[Ana C. Dent]

Re: Oracle Reports 6 recompilation

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.

[Ana C. Dent]

Re: Oracle Reports 6 recompilation

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_DEPENDEN CIES_MODE=SIGNA TURE

[FuzzyBear]

Re: Oracle Reports 6 recompilation

"Ana C. Dent" <anacedent@hotm ail.comwrote in message news:<22T2b.658 39$kP.64113@fed 1read03>...

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_DEPENDEN CIES_MODE=SIGNA TURE

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.