Forum Discussion

Karthikgs's avatar
Karthikgs
New Contributor
5 years ago

How to execute 20 different oracle sql queries using oracle execute snap

Hello Everyone,
Need your expert advise, I have 20 different set of sql queries running on the same table to generate the metrics, I am trying to run through them using Oracle execute but got error as “resolution:
Reduce the fetch size in the database connection configuration and retry executing the pipeline”

Is there anyway I can run the sql queries one by one without running it as a bulk sql query. Below is my pipeline

2 Replies

  • igormicev's avatar
    igormicev
    Contributor
    5 years ago

    Hi @Karthikgs,

    If you’re selecting/generating data then the snap won’t support such a series of commands, but if the queries do update/delete/insert then you shouldn’t have issues.

    So in order to overpass it, you can introduce a separate “Pipeline Execute” in which you’ll be executing the passed queries and save the result into a table in Oracle. Lastly, just query out the table(s) with the generated results.

    /Igor

  • Karthikgs's avatar
    Karthikgs
    New Contributor
    5 years ago

    Thanks @igormicev for your advise, will try your solution, thanks again for your time and feedback.