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.
user
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](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#importing-an-oracle-stored-procedure-that-returns-cursors) 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](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_derived_views/querying_views/execution_trace_of_a_statement#execution-trace-of-a-statement) 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