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!
