Hi all,

the situation:

an object-type:

create type PERS_TYPE as object (
p_id number(10),
lastname varchar2(254),
);

a function:

create or replace function get_pt (p_id in number) return PERS_TYPE
is
pt PERS_TYPE;
begin
-- some selections ...
pt.p_id := 10;
pt.lastname := 'XYZ';
return pt;
end;

And now the question: How can I select the values of the PERS_TYPE in an
select-statement like this

select get_pt(9999) from dual;

--> shoud deliver something like
get_pt(9999)
--------------
pt.p_id = 10; pt.lastname = XYZ

thanks in advance

Rüdiger J. Schulz
sosys-berlin.de



Oracle LazyDBA home page