Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ODBC Error
Guess you ran out of memory, check your cursor type: if stuff gets really
huge the only way to go is a forward only cursor.
Here is another example of that error:
To determine how many elements are being returned by the query, multiply the number of columns in the result set by the number of rows. For example, a result set of 2 columns and 2,700 records contains 5,400 elements, or cells.
Hope this helps
HSK wrote in message <809329$ls1$1_at_news.inet.tele.dk>...
>Hi
>
>I have a SQL-statement that draws some information from an Oracle 7.3.4
>database. If the result is very large, I get a ODBC Error 2042, but if I
>limit the result to fewer rows, I works fine.
>
>Can anyone help me explain why this occurs, and is there anything I can do
>about it?
>
>/HSK
>
>
Received on Wed Nov 10 1999 - 03:34:11 CST