Is there an oracle query which I can use to get back the details of an oracle function which returns a table, where I'm looking for the info of that table, say the record name, but mostly the columns in that record and their types.
create or replace function return_table return t_nested_table AS v_ret t_nested_table; begin v_ret := t_nested_table(); v_ret.extend; v_ret(v_ret.count) := t_col(1, 'one'); v_ret.extend; v_ret(v_ret.count) := t_col(2, 'two'); v_ret.extend; v_ret(v_ret.count) := t_col(3, 'three'); return v_ret; end return_table;
create or replace type t_col as object ( i number, n varchar2(30) ); create or replace type t_nested_table as table of t_col;
Knowing only the owner (system) and object name (return_table), I want to execute a query which will return for me the info of t_col. The names (i, n) and types (number, varchar2) of the columns
I can't just execute the query by itself cause there might be scenarios where there are required inputs for that function which won't be known at the time when I'm trying to only get the column info
I'll be executing this query in C# .Net