fetch multiple records using Native SQL

Former Member — Fri, 05 Sep 2014 16:23:12 GMT

Hello All,

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.

Re: fetch multiple records using Native SQL

rosenberg_eitan — Fri, 05 Sep 2014 18:27:02 GMT

Hi,

Check if this is useful in your case.

See here

I am using there:

cl_sql_connection

cl_sql_statement

cl_sql_result_set

cx_sql_exception

Regards.

topic Re: fetch multiple records using Native SQL in Application Development and Automation Discussions

fetch multiple records using Native SQL

Re: fetch multiple records using Native SQL