Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can cursors be cached in Pro*C dynamic sql?
On Fri, 05 Sep 2003 15:57:19 GMT, andreyNSPAM_at_bookexchange.net
(NetComrade) wrote:
>We are trying to reduce soft parses in our app.
>So far we've been able to cache cursors in embedded SQL in Pro*C, but
>had no success in caching cursors for dynamic sql. Since, in PL/SQL
>it's not possible to cache cursors for dynamic sql, I was wondering if
>it's possible at all to do in Pro*C, or if there are any workarounds
>(session_cached_cursors parameter doesn't help)
dynamic sql is *always* soft parsed
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address Received on Fri Sep 05 2003 - 17:07:12 CDT