Return Table in a Function [message #289946] |
Wed, 26 December 2007 17:10  |
Krann
Messages: 4 Registered: December 2007
|
Junior Member |
|
|
hi, i am new creating functions in Oracle and i want to know if it´s possible to return a table type from a user function. I knwon in Transact SQL is possible but i am not sure in PL/SQL.
i make this:
create or replace funcion <name>
return
is
type r is record(
c int
);
type t table of r;
begin
t(1).c:=3;
return t;
end;
But it have compiling errors.
Thank you for your help.
Krann.
|
|
|
|
|