Re: Very important: Problem with ORACLE SQL!

HI,

As the the cursors problem, look in the initSID.ora file on the server machine. Look for a parameter called open_cursors. It is too large. Complex applications can set it to several hundred without negative consequences.

Manuel Mießner wrote in message <6s3j5p$uij$1_at_news.centaur.de>...
>Hello.
>
>My System: Win Nt 4.0; Visual Basic 5.0 SP3 OO4O Classes; no ODBC. Connect
>via Oracle Object Library. Oracle 8
>
>I have two problems:
>
># 1: After an unknown count of youerys (via ExecuteSQL or CreateDynaset)
>i get the Oracle Error "Maximum Cursors ecxeeded: why? After every Quere i
>set the object
>to nothing.
>
>#2: This query doens't work. Why?
>
>Fielddefinitions:
>aukIndex = SmallInt
>gwzID=Integer
>gwzKernNr=Integer
>
>Query:
>SELECT gwzID, gwzKernNr, 'AK' + aukIndex as AKINDEX FROM tblGWZ,
>tblGWZ_AK,tblAK WHERE gwzID=a_g_gwzID and aukID=a_g_aukID and gwzKernNr =
>100189
>
>the problem part is " 'AK' + aukIndex as AKINDEX "
>
>Thanks for help.
>Manuel
>
>e-Mail: miessner_at_centaur.de
>
>
>
>
Received on Fri Aug 28 1998 - 23:22:22 CDT