You can translate the question and the replies:

How to expose Stored Procedure in denodo?

I have to expose store procedure in denodo from my Oracle database and customize it, how can I do that.
Components
user
17-10-2014 14:56:11 -0400
code

1 Answer

Hi, you will have to create a base view from query using your Oracle procedure syntax, for example: CALL schema.stored_procedure_name(@INPUT_VALUE_INTEGER, '@INPUT_VALUE_TEXT', ?, ?, ?) You have more information in the "Creating Base Views from a Query to a Stored Procedure" section of the Virtual DataPort Administration Guide (and if you are in Denodo 5.5, you can import the Oracle Stored Procedures graphically in the JDBC data source introspection tree).
Denodo Team
20-10-2014 07:47:28 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here