Re: Puzzled: CURSOR in Package

Thanks, but is this really a strong reason for declaring only cursor header in pkg spec ?
I mean first wrapping in-house source is rather rare in the corporate world, is'nt it ?
second, what's the justification for hiding the SQL from the developers ? That's not likely to make them more productive or accurate, is it?

Jane

> You may want it that way for security reasons - in a similar way to the
> Oracle supplied packages - the spec is typically readable from
> DBA_SOURCE but the body is wrapped. Thus, you could publicize the
> existence of a cursor to be shared, but not reveal its definition.
>
> hth
> connor
Received on Mon Nov 19 2001 - 12:06:41 CST