Re: [Orclib-users] reuse statements

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

Hi Vincent

4.0.1 under msvc and gcc(linux)

Regards
Luiz

2015-02-11 20:20 GMT-02:00 vincent rogier <vin...@gm...>:

> Hi,
>
> What version are you using ?
>
> Regards,
>
> Vincent
>
> On Sat, Jan 24, 2015 at 9:49 PM, Rafael Culik <cu...@gm...> wrote:
>
>> 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
>>
>>
>> ------------------------------------------------------------------------------
>> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
>> GigeNET is offering a free month of service with a new server in Ashburn.
>> Choose from 2 high performing configs, both with 100TB of bandwidth.
>> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
>> http://p.sf.net/sfu/gigenet
>> _______________________________________________
>> Orclib-users mailing list
>> Orc...@li...
>> https://lists.sourceforge.net/lists/listinfo/orclib-users
>>
>>
>
>
> --
> Vincent Rogier
>