Forum Discussion

Frantascia's avatar
Frantascia
New Contributor
5 years ago

Oracle Stored Procedure Snap with DBMS_OUTPUT

Greetings,

I have an Oracle stored procedure that produces DBMS_OUTPUT in the SQL server. How can I capture the output in the pipeline so that I can produce a CSV file from said output?

Thanks.

oracle_ebs
  • Aleksandar_A's avatar
    Aleksandar_A
    Contributor III
    2 years ago

    Hello GanguP.

    Would you be able to provide us a sample output, so we can better understand what you want to achieve? 

    Regards,

    Aleksandar.

    • GanguP's avatar
      GanguP
      New Contributor III
      2 years ago

      I am trying to extract the values including the array list and load into Snowflake. Below are the fields

      abandoned
      abandonSeconds
      acwSeconds
      agentId
      agentSeconds
      tagid
      tagname

      • Aleksandar_A's avatar
        Aleksandar_A
        Contributor III
        2 years ago

        Attached below is a sample pipeline that will flatten on tags array, so for every element in the tag array you will have a document with the above information from the parent contacts object.

        Let me know if this is what you are trying to achieve.

        Regards,

        Aleksandar.

  • koryknick's avatar
    koryknick
    Employee
    2 years ago

    GanguP - rather than specify the individual columns to retain, you can select the "Include scalar parents" checkbox.  As long as the element is a primitive datatype (i.e. not array or object), it will automatically let it pass through.

    • GanguP's avatar
      GanguP
      New Contributor III
      2 years ago

       Thank you so much @Kory  .  Appreciate your quick response