Re: [Ruby-DBI-devel] Problem with 'too many open cursors'

[KUBO T. <ku...@ji...>]

Brian Candler <B.C...@po...> writes:

> While running some code which does a lot of db.select_one and db.execute
> calls, I was getting Oracle errors saying 'too many open cursors' - although
> I had only a single DBI handle open.
>
> Digging around, I found that:
>
> - I should have been using db.do() not db.execute(); the latter returns a
>   sth which I was never using, so Oracle cursors accumulate until garbage
>   collection kicks in

Then, ruby-oci8 calls rb_gc() and retry it when the OCI call failed by
'too many open cursors' in the C API layer.

I'll do it, umm ;-(, at July 13.

-- 
KUBO Takehiro