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?