Re: Statements parsing from stored procedures

Hi Shailesh,

I'm glad you found a fix, but I am curious.

In your original problem statement, you were doing SELECT's inside a package and doing a lot of soft parsing, but the example above has simple INSERTs in a loop. Just to clarify, have you found a way to eliminate the soft parses for the SELECTs inside a loop of a PL/SQL program unit, or just for straight INSERT's? The INSERT's I can understand not being soft parsed, but I would like to know if you eliminated the soft parsing for the PL/SQL piece.

Regards,

Steve Received on Tue Apr 25 2006 - 10:46:05 CDT