Remote views in VFP8 (maximum open cursors exceeded)
The command "USE view CONNSTRING (m.nStatementHandle)"
works, and eliminates exessive statement handles. Oracle is happy,
therefore we are happy.
Remote views should have had a property to fix this, though...
Thanks for your help (and for saving my sanity)!!! :-)
Erlend.
Quote:
> VFP8 has a new command clause
> USE view CONNSTRING cConnectionString | (m.nStatementHandle)
> among other differences. VFP8 also use statement handles. You should
review
> the Help for
> the Search strings "statement handle" and "Connction handle"
> -Anders
message
> > Hi everybody.
> > We have a problem with remote views --> Oracle.
> > We have a system that was developed in VFP6 using remote views
> > with a shared connection through ODBC (MS ODBC for Oracle) to
> > an Oracle DBMS.
> > The VFP6 version ends up with one connection to Oracle and all
> > views uses this connection. This is easily confirmed by the
> > following SQL (using Oracle SQL*Plus):
> > select *
> > from v$session b,
> > v$open_cursor a
> > where a.sid = b.sid;
> > We converted the VFP6 source to VFP8 and built new applications.
> > When running the new VFP8-application we rather quicky run into
> > the Oracle message
> > "ORA-01000: maximum open cursors exceeded".
> > ... when using the same Oracle database. The above SQL gives
> > one connection per view (you can view part of the remote view SQL
> > from the results of the above SQL).
> > All views have the ShareConnection property set (or else the
> > VFP6-version woldn't have worked). The parameters set in the VFP8 DBC
> > is the same as used in the VFP6 DBC. As far as I can tell this
> > isn't connected to a particular version of Oracle.
> > Can't find any solution to this. Searched everywhere...
> > Am I missing something obvious? Is it a bug?
> > Erlend.
> > _________________________________________________________________
> > Facility Management as, N-9291 Troms? http://www.facilit.no/
