Hi All,
Oracle version:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for IBM/AIX RISC System/6000: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
Sorry if this question was asked previously.
There is a Database function which is used by our GUI to display few values returned by Oracle function.
I can run a select on SQL Navigator and output it shows as (Table) in one cell and when i double click it it opens two records index 0 and index 1 with values for both like:
index value
0 sys_plsql_99999_1 (date1,value........
1 sys_plsql_99999_1
If i click on any value, a table is opened with columns as :
attribute name value
start_dt 1-Jan-2019
....
..
and so on
We have access to Oracle function being called but not the Java code which used the return type.
The function returns a nested table of record type.
our requirement is to store the output of PL/SQL table returned from select statement into a physical table. Can someone redirect me to correct solution.
Thanks,
Nik