Can you manually exclude statement caching?

[xpiwo]

It it possible to explicitly exclude some statement from the cache? setDisableStatementCaching?

Thanks.

[krismohan]

Any reason why you need that? LRU ones are thrown off the cache if the cache is full.

[xpiwo]

i don't want to cache 'on the fly' dynamic statements and to push out cached statements.
eg list of different optional filters etc

[cjbj]

@xpiwo any chance you can use bind variables for this kind of statement? How's the statement caching working out for you in general?

@krismohan do you want to add a doNotCache option to execute() that indicates OCIStmtRelease should use OCI_STRLS_CACHE_DELETE?

[xpiwo]

It might be possible to use bind variables and pass a bunch of nulls/empty strings, but that's ugly.

The do not cache flag is the feature request i was aiming for :)

Thanks.

[krismohan]

It is feasible. OCI supports it as Chris mentioned.

[cjbj]

A new keepInStmtCache attribute in now available in node-oracledb 5.3 to handle this situation. Thanks for your patience!