Re: Can cursors be cached in Pro*C dynamic sql?

From: Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl>
Date: Sat, 06 Sep 2003 00:07:12 +0200
Message-ID: <082ilvoefsta327h5b5h3calqmbiue5bg1@4ax.com>

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