Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Create a view using OUT values from a procedure - how?

Re: Create a view using OUT values from a procedure - how?

From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Fri, 08 Oct 2004 07:41:37 -0400
Message-ID: <2sncntF1keck4U1@uni-berlin.de>


Mike,

If Oracle supports table or row functions you can use these. Otherwise you could pack the two results into a single structured type for return by the function and unpack on the view side.

just my 2 cents as an Oracle kibitzer

Cheers
Serge Received on Fri Oct 08 2004 - 06:41:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US