Q&A BY TAG 'Custom Functions'
Custom Functions and Denodo 8
answered
18-05-2022 01:22:31 -0400
Hi, Our organisation is currently using Denodo 7 and we have created a couple of Custom Functions which are used across different databases and projects. We are using a dev environment with Eclipse Oxygen and Java 1.8 and export the Custom Functions ...
Answers:
1
Denodo 8.0 Express - Extensions
answered
11-03-2022 17:07:16 -0500
I need test some custom function and did compile the sample function to jar. However, when I try to add it to Denodo. I don't see extension tab on extension management. I only see "Libraries" tab. File -> Extension Management -> (Only Libraries ...
Answers:
1
Create Base View for Oracle Function that returns Table Type
answered
25-08-2021 07:21:24 -0400
I am trying to create a base view on a Oracle function that returns data type - TABLE Trying this from the normal flow gives error : "Unsupported type TABLE for Database : Oracle Stored Procedure" How can i create this using a "Create Base View from VQ...
Answers:
1
Custom functions jar file renaming and name conflicts
answered
09-06-2021 18:20:55 -0400
Hello, When we started developing custom functions in Denodo, we had stored them all in a single package. However, we have now reached about 200 custom functions and in order to simplify maintenance, we would like to split that package in 3 (Date func...
Answers:
3
Denodo doesn't recognize local file within stored procedure
answered
07-06-2021 05:08:11 -0400
I have denodo platform 8.0 running on EC2 installed using cloudformation template as per the installation guide by Denodo. I am trying to create a custom stored proc which has to read a license file (locally saved inside /opt/denodo/denodo-platform8.0/...
Answers:
4
Logging Custom stored procedure ERROR_HANDLING Custom Functions License File Denodo Jar
Error while using custom function
answered
28-04-2021 00:31:32 -0400
Hi Team, I developed a custom function when I am using it I wm getting error com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxyException: error computing capabilities: Function 'psi_hashicorp_decrypt' is not executable. Can you please let me kno...
Answers:
3
Error while using custom function. com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxyException: error computing capabilities: Function ‘psi_hashicorp_decrypt’ is not executable
answered
16-04-2021 08:36:36 -0400
Thank you for the answering my previous question on custom funtion for the error com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxyException: error computing capabilities: Function ‘psi_hashicorp_decrypt’ is not executable. I didn’t find any synt...
Answers:
1
Error Handling with Custom Functions
answered
23-09-2020 08:46:44 -0400
Is there a mechanism by which a custom function can report an error? It appears that exceptions thrown are swallowed and it is treated as though the function returns null.
Answers:
6
Returning an existing compound type from executeReturnType
answered
29-06-2020 09:43:17 -0400
I have a bunch of complex compound types defined via CREATE TYPE syntax. Can I use them as a custom function return type, that is, return this type from executeReturnType()? E.g. something like this: @CustomExecutorReturnType public CustomRecordTy...
Answers:
1
how can I call a custom function created in Oracle DB from denodo
answered
31-12-2019 15:57:53 -0500
Hi , i have created a Pl/SQL function in underlying oracle database which set the context based on passed input user parameter. i want to call this function from denodo VQL. i imported this function in denodo by creating base view on it and then trie...
Answers:
1