Oracle Apex : How to get single values from a Oracle PL/SQL-table into Apex variables
Dear Oracle experts,
from an function I get a PL/SQL table which consists of a single dataset which is an object of several varchars.
Below the declaration of the object, the table and the function :
create or replace type mitgliederdaten as object
( /* TODO enter attribute and method declarations here */
EAdr_1 varchar2(5000),
EAdr_2 varchar2(5000),
EAdr_3 varchar2(5000),
EAdr_4 varchar2(5000),
EAdr_5 varchar2(5000),
EAdr_6 varchar2(5000),
EAdr_7 varchar2(5000),
EAdr_8 varchar2(5000),
EAdr_9 varchar2(5000),
EAdr_10 varchar2(5000),
EGBdat varchar2(5000),
EName varchar2(5000),
EVorname varchar2(5000),
EOK varchar2(5000)
)
create or replace type tab_mitgliederdaten
as table of mitgliederdaten;
function get_mitgliedsdaten_tab (mitgliedsnummer varchar2) return tab_mitgliederdaten;
I can query this construct like that in my SQLDeveloper :