Link to home
Start Free TrialLog in
Avatar of dvpiper
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?
ASKER CERTIFIED SOLUTION
Avatar of sandaruwan
sandaruwan

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial