RE: Concept clarification - Invalid packages

        The application in question is Business Objects, it acknowledges the
error about invalid packages and still returns partial results and lets the
user have them! Surely if an ORA- error comes up, the app should at least
warn the user the data may be not be correct and ask for another run to be
made?

        The changes are not always being made, they are made at a specific
time of day under a change management system. This was noticed by the BO
admin and he wants to know whats wrong with the database and why it's
allowing the partial result set to be sent back to BO!

        Thanks for your response.



-----Original Message-----
From: babette.turnerunderwood@xxxxxxxxxxxxx
[mailto:babette.turnerunderwood@xxxxxxxxxxxxx] 
Sent: 28 Jan 2005 13:10
To: GJohnson@xxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Concept clarification - Invalid packages


You are correct in what is happening for the package compilations.

The argument you are having with the developer is not really
a technical issue but a design issue. I agree with you, but
is there some business reason to return partial data that
the developer did not make you are of ?

And WHY are you changing the package while it is being used ???

- Babette

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Johnson, George
Sent: 2005-01-28 3:56 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Concept clarification - Invalid packages

[snipped]

        My understanding, possibly flawed, is that the 2nd SQL, the count()
is forcing the package to stay locked down until the result is completely
collated, finally counted and returned, before allow the package to be
manipulated. 

        The first SQL is constantly calling and releasing the package, so at
some point Oracle is allowing the rebuild package to jump in, the split
second it knows the package is no longer locked in use.

        Is my thinking correct or have I missed something stupidly
fundamental?


****************************************************************************
This message contains confidential information and is intended only 
for the individual or entity named.  If you are not the named addressee
you should not disseminate, distribute or copy this e-mail.  
Please notify the sender immediately by e-mail if you have received 
this e-mail by mistake and delete this e-mail from your system.
E-mail transmission cannot be guaranteed to be secure or error-free
as information could be intercepted, corrupted, lost, destroyed, arrive
late or incomplete, or contain viruses.  The sender therefore does not
accept liability for any errors or omissions in the contents of this 
message which arise as a result of e-mail transmission.  
If verification is required please request a hard-copy version.
This message is provided for informational purposes and should not
be construed as an invitation or offer to buy or sell any securities or
related financial instruments.
GAM operates in many jurisdictions and is 
regulated or licensed in those jurisdictions as required.
****************************************************************************

--
http://www.freelists.org/webpage/oracle-l

Other related posts: