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

  • ddellsperger's avatar
    ddellsperger
    Admin
    2 years ago

    If your api is simply expecting an array of your internal JSON object, you can change the http entity that you're sending (assuming your'e sending a raw http entity using the full document $) to [$] and that will wrap your document in an array.

    • vish_ch's avatar
      vish_ch
      New Contributor
      2 years ago

      Hi ddellsperger ,

      It is actually the reverse.
      The output of mapper is Json object but while making post call bosy is sent as json array, so there is extra [] in body which I don't want.

      Any clue how to solve this.

      yes, I am using raw entity and sending full document as $

      • ddellsperger's avatar
        ddellsperger
        Admin
        2 years ago

        can you DM me a link to your pipeline, I can look into this a bit more there.