Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Strange open cursors for "select null from dual" on Oracle 9i and 10g

Re: Strange open cursors for "select null from dual" on Oracle 9i and 10g

From: Michael Pfeifer <muchinger_at_web.de>
Date: 8 Apr 2005 04:26:16 -0700
Message-ID: <91b29f39.0504080326.67600f72@posting.google.com>


yong321_at_yahoo.com wrote in message news:<1112793518.460438.285480_at_z14g2000cwz.googlegroups.com>...
> Can you try adding CSR=T to your connect string (separate it from the
> other part with semicolon)? This is explained in ODBC Help, "Format of
> the Connection String (Programming)". CSR means "close CurSoR enabled".
>
> Yong Huang

Well we do not use a connection string, we use an ODBC datasource. The datasource configuration allows to set an "Enable Closing Cursors" checkbox, which is exactly the same as using CRT in the connection string.
Thanks anyway. Received on Fri Apr 08 2005 - 06:26:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US