How to retrieve large data from oracle database using vbscript
Posted
by allenzzzxd
on Stack Overflow
See other posts from Stack Overflow
or by allenzzzxd
Published on 2010-06-14T09:04:42Z
Indexed on
2010/06/14
10:22 UTC
Read the original article
Hit count: 195
Hi guys,
I'm now working on vbscript to do some test. Actuelly, I want to retrieve a large amount of data from an oracle database, so I write the code like this:
sql = "Select * from CORE_DB where MC = '" & mstr & "' "
Set myrs = db_execute_query(curConnection, sql)
Then I count the rows in myrs,there are 248 rows. So then I do a For loop to retrieve some fields of each row.
For k = 0 To db_get_rows_count(myrs)
But then I found that the content of the row k when k > 133 was always equal to k = 133. So this makes an error.
As I think, there may be a limit size of mrys ? Could anyone light me about this? Thanks a lot in advance
© Stack Overflow or respective owner
