Latest Activity
we have two denodo installation with same version(8.0.20220126) in two different machines. If we call get_elements() store procedure from machine 1, we getting 24 columns in resultset. But when we call the same get_elements() store proc from machine 2,...
Trying to create base view from an Oracle Stored Procedure... following message appears "Unsupported type PL/SQL RECORD type for database: Oracle Stored Procedures". Anyone has solved this?
How can i achieve this.. I am having couple of tables T1 with column C1, C2, and C3 T2 with column D1, D2, and D3 I need to look into a table T1 based on where condition (where C1 = 'ABC') and check if column C3 having value. - If so i need to pick...
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...
I have a SQL Stored Procedure which I will use to create a Base View in Denodo. The issue is that the Stored Procedure takes an User-Defined Table type as input parameter. If I select the SP and click Create from Selected I get an error that says the ...
Hi, I was wondering if you could tell me if there was a way to create a base view on snowflake stored procs. What I am trying to do is: Run the stored proc Capture the result of the proc The Snowflake statments are like these: -----CALLING ...
Hi, please I have stored procedure exist at teradata source and I need to create baseview using this stored procudre , so I tried to make base view by using create from sql query and type call pocedureName() but error appears " [Teradata Database] [Ter...
Hello team, As we know, in Denodo we can give a view level access for a role. I have a situation where I need to give access to a SINGLE view to MULTIPLE roles(around 30). The procedure is to select each role, click on edit in the database and give wh...
Denodo stored procedure database assign privilages Base View descrptions Access and Role Stored Procedure VQL Role Role and User Management Roles Users
Hello, Is it possible to create a view using a Denodo Stored Procedure or incorporate a Denodo Stored Procedure in an existing view. I need to count the total number of rows in the output of a view and then take that total count and include it in that ...
Hi, I created base view from SQL stored ptocedures. Function have 2 mandatory parameter. When where clause for 2 mandatory field and on additinal field. then manadatory field is filtered by source. But additional field is filtered by Denodo. My Quest...