Re: Pragma Restrict_References Question.

First Sorry about not posting the version, my oversight. It is version 9.2.0.1.0

I understand that it is no not necessary to use these pragmas in Oracale 9i but I was also under the impression that it was still good practice. I did read the docs and found that if you don't declare your pragma explicitly Oracle had to determine at runtime if the function was safe for use in a select statement. So if you declare it in the package then you can save a little bit of time.

Finally the application itself will never use this function in a select. However, we have a lot of reports that will need to be run, and while we could split it out into a cube our users may not have the ability resources skill or staff to maintain the beast. So we give them the option of running the reports against our database, and they are warned ahead of time to schedule these reports for periods of low DB activity etc. So I know it wouldn't be scalable if these were peppered throughout the code, but in our case we do have a reason for what we are doing...

Now despite all the caveats, which is better approach?

Thanks,
Bill

under the impression that it still made sense to use them. "Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:p871fv03cgquvdsj2fqrm8tpum29fsg82g_at_4ax.com...
> On Wed, 18 Jun 2003 16:44:37 GMT, "Bill Lucas"
> <Homebrew42_at_hotmail.com> wrote:
>
> >We have a project currently in development (our first Oracle project
> >actually).
>
>
> Then you should learn two things now:
> 1 Always post your version
> 2 Always read the manual before posting. In 8i and higher this pragma
> is obsolete.
>
> So this leads to the assumption for your *first* project you are using
> an obsolete and prehistoric version like 8.0 or, God forbid, 7.3,
> which both have been desupported several years ago.
>
> Also: using a function with embedded selects in a select is just
> asking for performance trouble and a non-scalable application.
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Wed Jun 18 2003 - 14:01:17 CDT