i found some bugs on Metalink for 10.2 and ref cursors and stored procedures. a problem affecting JDBC as well as OCI.
could be affecting 9206 also. i think you could raise an SR and get it sorted out, could be a bug.
I was not aware of this and of course it explains the symptoms, and why session_cached_cursors has worked.
*From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Riyaj Shamsudeen *Sent:* 26 September 2006 16:20 *To:* Bernard.Polarski@xxxxxxxxxxxxxx *Cc:* oracle-l@xxxxxxxxxxxxx *Subject:* Re: PLSQL CPU consumption
Of course, since you use ref cursor, they MUST be soft parsed. Read Tom Kyte's website.
-- All I need to make a comedy is a park, a policeman and a pretty girl - Charlie Chaplin