Q&A BY TAG 'Custom Functions'
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
Calling Simple API from Custom function/Procedure
answered
30-08-2019 08:39:24 -0400
Hi Team, We have a customer requirement to call the encrption/decrytion activity which will be via simple API from denodo layer.Could you please help /support us how to create custom function/procedure in Java to call simple API from Denodo Thanks Balu S
Answers:
3
Logger for Custom Function
answered
19-03-2019 05:51:18 -0400
Custom Policies has a context object available which can log into Denodo server logs. On similar lines, do we have any object available for Custom Function which can log into Denodo server logs?
Answers:
4