Q&A BY TAG 'Stored Procedures'

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

Fetching View's underlying query
answered 16-10-2020 08:53:59 -0400

Hi Denodo team, I have a requirement of fetching view and also the query through which this view is created if that view is created by query.I have tried GET_VIEWS(), CATALOG_VDP_METADATA_VIEWS() and CATALOG_METADATA_VIEWS() procedures.But none of them...

Answers: 1

Base view Stored Procedures query logs Denodo view

List Procedure Jar Dependencies
answered 04-02-2020 09:08:35 -0500

Hi I am looking for denodo metadata views which can give relationship of user defiened stored procedures and Jars with version. I have used the "LIST JARS" catalog function. This function returns the JAR name and stored procedure or functions of that ...

Answers: 1

metadata store Denodo stored procedure Stored Procedures

Weird dependency name in COLUMN_DEPENDENCIES() stored procedure
answered 01-11-2018 18:14:44 -0400

Hi all, I have a problem when executing COLUMN DEPENDENCIES() procedure. I had a derived view with just one column coming from a web service base view and I have modified the model and the output to add another derived view, and now when calling the p...

Answers: 1

Stored Procedures dependency_name

Missing Stored Procedures
answered 23-10-2018 08:28:02 -0400

Hello, I'm using Denodo 6.0 Quickstart VM with a Denodo Express License and I'm trying to run some stored procedures that documentation says they come out-of-the-box with the product, but I'm missing some of them, so I'm just wondering whether it is a...

Answers: 3

Stored Procedures

Denodo , Stored Procedures, & Insert Updates
answered 15-03-2018 09:15:24 -0400

Have a questions, Why we need store procedures and insert update operations in Data Virtualization tool.

Answers: 1

Stored Procedures DENODO Insert Operation

Stored procedure returning data only with "call" statement and not with "select"
answered 26-12-2017 07:24:00 -0500

I have created a stored procedure which returns an Array. It is not performing any DML operations and is only retrieving data, parsing it and giving back an array. However, I can only view the data using "call" statement. The "select" statement is retu...

Answers: 5

Stored Procedures

STORED PROCEDURES NOT DISPLAYED IN TREE DATA SOURCE
answered 26-12-2017 07:03:05 -0500

Hi: I'm attempting to execute the LAB03 however stored Procedures are not displayed in the data tree source. Can you please let me know why are not displayed? If something is missing? I attach the image where procedures are correctly created in MYSQL b...

Answers: 1

Stored Procedures

Error when running CLEAN_CACHE_DATABASE procedure
answered 17-07-2017 08:18:25 -0400

I am getting the following error when I try to run the CLEAN_CACHE_DATABASE stored procedure via VQL shell: select * from CLEAN_CACHE_DATABASE('<vdb_name>'); Finished with error: The user does not have READ privileges on the procedure 'clean_cac...

Answers: 1

Stored Procedures CALL CLEAN_CACHE_DATABASE

Other way to create function or procedure?
answered 07-07-2017 10:36:17 -0400

Is the there a way to create custom function without using without third party app such as eclipse?

Answers: 1

Function Stored Procedures

Stored Procedure- SP
answered 06-06-2017 05:54:10 -0400

I assume to do procedural programming in denodo we need to use Java. Is there any option to use Ansi SQL / PLSQL kind of Procedural langauage in denodo ?

Answers: 1

Stored Procedures