dvpiper
asked on
Create or Replace Function(...) RETURN Record AS
I need to write an Oracle Function that will return 2 values.
I thought I could use a record type for the return, but don't know how to code it.
Essentially:
create or replace function thisFunction(input parameters ... ) RETURN Record
AS
t_rec TYPE Record
(
amount number,
descirption varchar2(100)
);
r_rec t_rec;
BEGIN
... code
RETURN r_rec;
END thisFunction;
Can an expert provide the skeletal structure for such a function that will return a TYPE record?
I thought I could use a record type for the return, but don't know how to code it.
Essentially:
create or replace function thisFunction(input parameters ... ) RETURN Record
AS
t_rec TYPE Record
(
amount number,
descirption varchar2(100)
);
r_rec t_rec;
BEGIN
... code
RETURN r_rec;
END thisFunction;
Can an expert provide the skeletal structure for such a function that will return a TYPE record?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.