Hello,
In 12c do you know a way to tell Oracle to stop creating different versions of SQL cursors ?
Say I have a statement like:
select * from table where column = :A1
It *seems* (from our investigations) that if the application sends hundreds or thousands
of A1 variables (varchar2 in this case) having different lengths, another version of this
cursor will be made.
We would like to disable this behaviour - but is it possible ? (tell Oracle "OK now you've
got one version, that's enough, don't bother making a new one"...)
Thanks a lot.
Regards,
Seb