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
user
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](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#creating-base-views-from-sql-queries) option. * Then, write the query and replace the input parameters[ interpolation variables](https://community.denodo.com/docs/html/browse/8.0/vdp/administration/creating_data_sources_and_base_views/path_types_in_virtual_dataport/path_types_in_virtual_dataport#paths-and-other-values-with-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?](https://community.denodo.com/answers/question/details?questionId=9060g0000004FWYAA2&title=Can+i+create+dataType+of+table%3F) and [Need help creating a Base View from a SQL Server Stored Procedure](https://community.denodo.com/answers/question/details?questionId=9064u0000004FocAAE&title=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