You can translate the question and the replies:

Passing Parameters

I have created a view for a Oracle Stored procedure which returns a oracle refcursor as output. The Oracle stored procedure has some input parmeters. Oracle stored procedure parameters are optional meaning if we pass a parameter it filters else it retuns all the records. Its working fine in Oracle. Some parameters expect multiple values as input. I am trying to specify "IN" clause while filtering but Denodo view is not returning any data. Can you please help me with this.
14-09-2018 12:27:43 -0400

1 Answer

Hi, For this scenario, I would perform the following checks: * Refer to the [Importing Stored Procedures from Oracle]( section of the Virtual DataPort Administration Guide to verify if all the recommendations have been followed when importing the procedure. * Execute the view that is created over a stored procedure of Oracle and check the [Execution Trace]( to know what is being delegated to the source. Hope this helps!
Denodo Team
18-09-2018 05:54:44 -0400
You must sign in to add an answer. If you do not have an account, you can register here