Re: HELP: Stored Procedure performance question

From: Simon Hedges <shedges_at_hhhh.freeserve.co.uk>
Date: Mon, 17 May 1999 18:33:18 +0100
Message-ID: <7hpjq2$ln6$1@news4.svr.pol.co.uk>

Hans wrote in message ...

>Are you sure that it is compiled! from my point of view it is normally
>impossible
>that PL/SQL Procedures are compiled (the execution plan is determined).
I'm
>just a beginner in Oracle, but there are features that I think makes it
>impossible
>that proc are compiled.

Oracle certainly claim that they are compiled. There was a lot of stuff in earlier versions of Oracle 7 about not using triggers for large volumes of code, but using a trigger to call procs, because procs were compiled.

(this is now obsolete because from 7.3, triggers are also compiled).

Simon Hedges
Gloucester
UK Received on Mon May 17 1999 - 12:33:18 CDT