Re: Puzzled: CURSOR in Package

>>...Just think of the packaged cursor as a subroutine --
>>the interface......

Aha ! that's the gist of the concept I was missing ! That clears it up.
Thanks Tom and everyone !
jane

"Thomas Kyte" <tkyte_at_us.oracle.com> wrote in message
> recompiling the spec invalidates all dependent code.
> recompiling the body does not.
>
> The spec should never change, the body can be reimplemented over and over
and
> over without the cascading invalidations.
>
> Its like why we just put the prototype of the functions/procedures of the
> pacakge in the spec and their implementation in the body. Just think of
the
> packaged cursor as a subroutine -- the interface (inputs/outputs) goes
into the
> spec, the implementation (the query) into the body. You can change the
> implementation without affecting (invalidating and forcing recompilation)
of all
> dependent code.
Received on Tue Nov 20 2001 - 12:54:45 CST