PL/SQL (MOSC)

MOSC Banner

Oracle Apex : How to get single values from a Oracle PL/SQL-table into Apex variables

edited Sep 14, 2015 5:56AM in PL/SQL (MOSC) 2 commentsAnswered

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 :

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center