fetch multiple records using Native SQL
I am trying to fetch data from an external database which is an oracle sysrtem.
I am currenty using cursor method to fetch the data.
The "fetch next cursor1" only bring 1 record at a time. And it is taking more than 20 mins to bring 1 record, it seems the table i am fetching has more than 12 million records.
Can someone please answer these 2 questions:
1) If is have oracle commands to query their tables, can i use them directly between the EXEC SQL and ENDEXEC.
When i put a semicolon its giving error. Oracle statements end with semicolon.
2) There must be a way of fetching a set of records at one go from external system. Does anyone know the technique.
I appreciate your help.