Re: 10053 trace for sql fired from pl/sql (stored code)

On 22/12/05, Radoulov, Dimitre wrote:
>
> > "the query must be (hard) parsed and it must be parsed by the CBO". Maybe
> the original poster is missing these requirements.
>
> I tried to force the hard parse with lower/upper case and different
> comments.
>
> I suppose I'm missing something, so if anyone else could try :)

alter system flush shared_pool;

is your friend.

Oh, and if you don't know about:

alter system flush buffer_cache;

in 10g, it can be useful in other circumstances.

Cheers, and have a good Christmas all.

---Phil

--
http://www.freelists.org/webpage/oracle-l