Call oracle function returning reference cursor

pnaik1
pnaik1 Registered Posts: 23 ✭✭✭✭
edited July 16 in Using Dataiku

Is there any way we can call Oracle function returning reference cursor. I am using following SQL query to call it but it is not returning any value:

SELECT DBNAME."DATAIKUEXTRACT$B".FunctionName(TO_DATE('2020-07-09','YYYY-MM-DD') ) XXX FROM DUAL;

Answers

  • CoreyS
    CoreyS Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Registered Posts: 1,150 ✭✭✭✭✭✭✭✭✭

    Hi, @pnaik1
    ! Can you provide any further details on the thread to assist users in helping you find a solution (insert examples like DSS version etc.) Also, can you let us know if you’ve tried any fixes already?This should lead to a quicker response from the community.

Setup Info
    Tags
      Help me…