pin options

[jschmied]

Hi!

Is a object pinned with OCI_DURATION_SESSION or OCI_DURATION_TRANS??

Thanks

Juergen

 

[Marco Kalter]

All object instances are pinned for the duration of the session (OCI_DURATION_SESSION).

------------------
Marco Kalter
Allround Automations

 

[jschmied]

Can this be the cause for
http://www.allroundautomations.com/ubb/Forum1/HTML/000946.html
???

we still have this problem ;-( causing major pain. If it can't be fixed we have to look for other access methods than DOA.

Can't it be made as a Option???

Thanks

Juergen

 

[Marco Kalter]

If you pin a reference, then you need to explicitly free the resulting object instance. Once you free it, all associated memory is released, both in Direct Oracle Access and in the Oracle Net cache. Note that some Oracle Net versions may have memory leaks.

------------------
Marco Kalter
Allround Automations

 

[jschmied]

The Problem persists with several 8.xx and 9i Clients. I assume the problem is caused by nested oracle objects.
... and yes, I do a Free with every pined reference.

;-((

Thanks

Juergen