Skip to Content
author's profile photo Former Member
Former Member

Using ORACLE Procedure with Ref Cursor output as source in SAP Data Integrator

Hi everyone,

We need to use Oracle Procedure with a Ref Cursor output parameter as a source in SAP Data Integrator, we are searching, and we can't find out a solutions or workarround for that.

For us now is not possible to modify the procedure to store the result in a table and then use the table as source, for that reasen we need to find a way to call the Procedure directly in DI and get the resultset from the ref cursor.

Best Regards,

Martin

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Sep 23, 2015 at 06:25 AM

    I don't have access to an Oracle environment so I cannot test whether calling the stored procedure from a SQL transform would work or not.

    Is there anybody out there who would want to give this a try?

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Dirk, Martin,

      I found out some more useful points

      Please refer to Section of 6.5.5 Structure of a stored procedure of Data Services Reference Guide

      Data Services omits a parameter if any of the following data type conditions is true:

      • Is not a Data Services supported data type or is long

      • Data type is missing in the database dictionary

      • Is a composite data type (e.g., table, record, or cursor)



      After Data Services imports a stored procedure, the Designer reports warnings about any omitted parameters.

      Note:

      Even if a stored procedure has an omitted parameter, the procedure is callable if the parameter has a

      default value defined. If the omitted parameter does not have a default value, the procedure is not

      callable and Data Services throws a runtime error.


      Only BusinessObjects Universe Designer or IDT support usage of Stored Procedure with Ref Cursor.


      https://irfansworld.wordpress.com/2012/11/17/what-you-should-know-about-stored-procedure-universe-in-bi-4-0/

      Regards

      Arun Sasi

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.