sql - How to retrieve large data from oracle database using vbscript -

Now I am working on VBScript to perform some tests. In fact, I want to get a large amount of data from an Oracle database, so I will write the code like this:

  select from CORE_DB * where MC = '' & amp; Mstr & amp; "Set Mys" = db_execute_query (curconnection, sql)  

Then I count the rows in myrs , there are 248 rows Then I loop a to retrieve some areas of each line.

 For  from k = 0 to db_get_rows_count (myrs)  

But then I found that the content of the line k was always equal to k> 133 k = 133 . This creates an error.

The db_execute_query function is like

  function db_execute_query (byRef curSession, SQL) set rs = curSession.Execute ( SQL) db_execute_query = rs end function  

db_get_rows_count is like function

  function db_get_rows_count (byRef currS) dim lines Rows = 0 db_get_rows_count = rows cursor Go ahead first. EOP rows = rows + 1 curl. Next front loop db_get_rows_count = end function of rows  

Like I think, strong> mirage ? Can anyone stop me from this? Thanks a lot in advance

It would be useful to know exactly what is in the database Using SQLPlus, PL / SQL Developer, Tod, etc.) can connect to your database and execute your query? And if you do this, what results do you get when you execute your query through VBSPR?

In addition, do you get an error from the database? This can help in deciding what is happening.