Home » SQL & PL/SQL » SQL & PL/SQL » what is the best way to make my function return 3 table columns to my procedure
what is the best way to make my function return 3 table columns to my procedure [message #36367] Wed, 21 November 2001 02:12 Go to next message
krs
Messages: 9
Registered: November 2001
Junior Member
Hi,
What is the best way to make the function return 3-4 table columns to a procedure.

function fun1() return ....(what should be the best return type to return 3 table columns to the procedure here)

procedure test(..) is..

(what is the best way to make the 3 column values to be hold which are returned by the function.)

var1 tab1.col1%type;
var2 tab1.col2%type;
var3 tab1.col3%type; -- what is the alternative for this instead of 3 columns

begin

....:= fun1();

insert into tab2 values(..i want to insert all the 3 column values which are returned by the function)

end;

Any help is appreciated.

Srini

----------------------------------------------------------------------
Re: what is the best way to make my function return 3 table columns to my procedure [message #37132 is a reply to message #36367] Sat, 19 January 2002 20:37 Go to previous message
dinakar shetty
Messages: 29
Registered: January 2002
Junior Member
reutn
a package table type
type sss is record
(
a datatype
b datatype
b datatype
)

type xx is table of sss

return this table type from ur function
Previous Topic: how to use input parameters to create a table?urgent!
Next Topic: Re: password
Goto Forum:
  


Current Time: Tue Mar 31 10:40:56 CDT 2020