Q&A BY TAG 'Custom Functions'

You must sign in to ask a question. If you do not have an account, you can register here

How to return query error in denodo custom function
answered 02-09-2022 13:44:50 -0400

I used denodo VDP version 8.0 i build custom function successfully. however, when there is a error proccess in function, it always return null value. how to handling the error/exception to direct stop the query process? i don't want when it happen q...

Answers: 3

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

Custom Functions

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

extension 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

VQL VQL Base view Custom Functions Stored Procedure Oracle

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 8.0 extension Custom Functions

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 License File Custom Functions 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

Custom Functions

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

Custom Functions

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

Function ERROR_HANDLING Custom Functions Error Handling

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

Custom Functions Compound Types