Output parameters for procedure

From: Keith E. Jennings <kej2_at_Ra.MsState.Edu>
Date: 23 Jul 1999 20:58:40 GMT
Message-ID: <7nal20$evf$1_at_nntp.msstate.edu>

how can you type the output of a procedure so that it gives you a table?

I have a piece of code like this:

procedure a (in_ssn in number, out_table out borrows) as begin

	select (*)
	into out_table
	from borrows
	where in_ssn = borrows.ssn;

end;

where borrows is a table containing a column "ssn". how can I type out_table so that I can (from formbuilder 5) make a date block from this procedure and output a table? I've tried %rowtype and %type but in formbuilder I keep getting "type record is not allowed as a parameter". what can I do to get output as a table?

thanks
keith
kej2_at_ra.msstate.edu

-- 
Keith E. Jennings
THE Funkomatic

Received on Fri Jul 23 1999 - 22:58:40 CEST