You can translate the question and the replies:

Create Base View for Oracle Function that returns Table Type

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 VQL" ---- Any samples? I am using Denodo 8.0
24-08-2021 21:14:42 -0400

1 Answer

Hi, The Virtual DataPort supports table types when they are used as the return value of an oracle table-valued function in some cases like when table elements have only one field, etc. To create a base view on an Oracle function that returns ‘TABLE’ data type, you could follow the below steps: * When creating a Base View, select the [Create from Query]( option. * Then, write the query and replace the input parameters[ interpolation variables]( like @VARIABLE. * Click OK and enter the values of the variables(any possible sample values) used in the query. * If you need to modify the query used for introspection you can click on the Source Refresh button. You can refer to the similar Community questions [Can i create dataType of table?]( and [Need help creating a Base View from a SQL Server Stored Procedure]( for more information. Hope this helps!
Denodo Team
25-08-2021 07:21:24 -0400
You must sign in to add an answer. If you do not have an account, you can register here