You can translate the question and the replies:

Converting Oracle Functions to Denodo

Hello, I have an Oracle function that takes a few parameters and spits back out an output based on the logic inside the function. From what I can tell about Denodo, in order to be able to use this function, we would have to convert it to Java and then import it into Denodo, correct? Ultimately, I'm creating a custom policy that is very similar to a function that we use in Oracle. I noticed that I can go in Denodo and click on our data source, and then find that function in the "Stored Procedures" area when creating a base view. But then, I can't get the function to work and take my parameters and give me a return. If I'm correct, is this the same for procedures? If the procedure was to take parameters and give me an output, would this have to be converted to Java as well?
user
10-03-2021 15:07:55 -0500

1 Answer

Hi, Yes, if you want to create a custom function similar to Oracle in Denodo, then I suggest you take a look at some of the samples in the <DENODO_HOME>/samples/vdp folder. For stored procedures, you could take a look at the same samples folder for some stored procedures examples. With these samples as starters, you can develop your own custom function/stored procedure and then import the .JAR file in Denodo. I referred to the following user manuals: * [Developing Custom Functions](https://community.denodo.com/docs/html/browse/8.0/en/vdp/developer/developing_extensions/developing_custom_functions/developing_custom_functions) * [Developing Stored Procedures](https://community.denodo.com/docs/html/browse/8.0/en/vdp/developer/developing_extensions/developing_stored_procedures/developing_stored_procedures) Hope this helps!
Denodo Team
12-03-2021 05:37:37 -0500
You must sign in to add an answer. If you do not have an account, you can register here