[Orclib-users] reuse statements

[Rafael C. <cu...@gm...>]

Hi
Is possible to reuse the same OCI_Statement variable multiple times?

I have an small program that i prepare an select statement and save it
prepared handle to an variable .
when i call the first time, it execute ok, but on second pass

here the call stack

╔═[■]═Stack═════════════4═[↑][↓]═
║OCI_BatchErrorClear(:03ED46B8)      on stament.c line 1432
║OCI_ExecuteInternal(:03ED46B8, 1
║OCI_Execute(:03ED46B8)
║getPreparedSeekora(:047BFEE4, 1,
║#..\source\sqlex1ora#sqlExOraSee


also when i finish I call OCI_StatementFree inside getPreparedSeekOra

so for reuse, i can supress the call to OCI_StatementFree inside
getPreparedSeekOra?

Regards
Luiz