RE: Concept clarification - Invalid packages

From: Johnson, George <GJohnson_at_GAM.COM>
Date: Fri, 28 Jan 2005 13:19:55 -0000
Message-ID: <ECD91EB68018C04CA1B6801EE47A910F335C7528@ntas-ldn15.gam.com>

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_at_sdc-dsc.gc.ca
[mailto:babette.turnerunderwood_at_sdc-dsc.gc.ca]
Sent: 28 Jan 2005 13:10
To: GJohnson_at_GAM.COM; oracle-l_at_freelists.org 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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Johnson, George
Sent: 2005-01-28 3:56 AM
To: oracle-l_at_freelists.org
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

Received on Fri Jan 28 2005 - 08:22:32 CST