Re: A good challenge for gurus

From: Ivan Bajon <iba_at_no_spam@post1.tele.dk>
Date: Wed, 20 Oct 1999 14:02:33 +0200
Message-ID: <7ukb0r$fgc$1@news.inet.tele.dk>

What happens if you touch the package by executing a procedure? (Make sure you execute a harmless one)

Regards,
Ivan Bajon, ocp

Reza <reza_at_digital-dispatch.co.uk> wrote in message news:940415756.13251.0.nnrp-04.d4f07aaa_at_news.demon.co.uk...
> Hi
> I am trying replace (CREATE OR REPLACE PACKAGE BODY ...) in 7.3.4.0
> The package is big ( maybe 5000 lines). SQL*plus says "PACKAGE CREATED
> SUCCESSFULLY" and obviously no errors. The time stamp (Last modified) on
the
> package shows that it has just been modified BUT the code changes is not
> there (looking into the source code of the package in the server.
> Please don't tell me that I'm compiling an old code,I have done it three
> times.
> I think it is a problem with memory allocation in SGA (shared pool) to
> compile the package, but why it does not signal ora- 4031 ??
> I am compiling the package when the system is open and busy and lot of
users
> on the system and the package might be used but why no errors
> Please shed some light
> Thanks in advance
> regards
>
>
>
>
>
>
>
>
Received on Wed Oct 20 1999 - 07:02:33 CDT