Q&A BY TAG 'Stored Procedure'

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

Is it possible to connect to Oracle Stored Procedures?
answered 02-12-2021 07:31:22 -0500

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?

Answers: 1

Stored Procedure Oracle

Custom Script
answered 29-09-2021 03:29:08 -0400

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

Answers: 1

Custom stored procedure custom script Stored Procedure

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

Need help creating a Base View from a SQL Server Stored Procedure
answered 18-08-2020 08:14:29 -0400

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

Answers: 3

Base view Create Base View Stored Procedure SQL Server

Creating A Base View On Snowflake Stored Proc/ Multiple Statements
answered 22-07-2020 18:04:16 -0400

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

Answers: 1

snowflake Base view Create Base View Stored Procedure

Create base view from exist stored procedure at teradata source
answered 08-06-2020 08:43:40 -0400

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

Answers: 1

Base View descrptions Stored Procedure Teradata

Provide access to SINGLE view to MULTIPLE roles
answered 05-11-2019 08:54:33 -0500

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

Answers: 3

Denodo stored procedure database assign privilages Base View descrptions Stored Procedure Access and Role VQL Role Role and User Management Roles Users

Creating a view from a Denodo Stored Procedure
answered 19-08-2019 03:04:04 -0400

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

Answers: 4

Stored Procedure

Delegate SQL Sentence as Sub Query not passing to source
answered 23-07-2019 01:57:09 -0400

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

Answers: 1

subquery Execution plans Stored Procedure derived view

Joining View Created From Stored Procedure to View Created from "Create from query" option - Not Working
answered 17-07-2019 09:46:41 -0400

Hello, Can a view created from a stored procedure be joined with a view created from the "Create from query" option? I have a report that runs perfectly now. The report is generated from a view created from a stored procedure joined to a view created t...

Answers: 5

baseview created from query Stored Procedure