Q&A BY TAG 'Stored Procedure'

Which stored procedure can be used to get the source object name for salesforce baseviews .I cannot use GET_SOURCE_TABLE as it gives the result only for jdbc connections?

Base view Stored Procedure Salesforce

Hi Denodo Team, I'm using the Denodo Design Studio Version 8.0 20230301 and trying to create a VQL Stored procedure using the EXECUTE command as described in the user manual : https://community.denodo.com/docs/html/browse/8.0/en/vdp/developer/develop...

Stored Procedure

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,...

Stored Procedure GET_ELEMENTS

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?

Stored Procedure Oracle

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...

Custom stored procedure custom script Stored Procedure

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...

VQL VQL Base view Custom Functions Stored Procedure Oracle

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 ...

Base view Create Base View Stored Procedure SQL Server

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 ...

snowflake Base view Create Base View Stored Procedure

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...

Base View descrptions Stored Procedure Teradata

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