no. of rows retrieved from oracledatareader
209838Feb 25 2003 — edited Mar 21 2003Greetings,
Backgroud: I'm trying to use the most efficient method to copy a set of data from 1 Database to another. Both the target and destination tables have the same schema.
Details: Here's what i've done.. retrieve from Database1 records via oracledatareader. Next loop the reader and assign values to parameter(arraybinding). Lastly, arraybinded values as parameters to insert into Database2.
Question:
1) How do i get the no. of rows returned from the data fetched. I need this figure to allocate the arraybindcount for the insertion to another Database.
2) Is the above way recommended? I di not use dataset method of merge, as i know of the amount of overheads. I've not look into cursor yet.
Thnks.
alvin appreciates it.