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

Home -> Community -> Usenet -> c.d.o.misc -> Returning multiple columns from Stored Procedure for use in a View.

Returning multiple columns from Stored Procedure for use in a View.

From: <john.roberts.2004_at_gmail.com>
Date: 15 Aug 2006 07:21:44 -0700
Message-ID: <1155651703.810769.15300@i3g2000cwc.googlegroups.com> 





Hello,



I am using an oracle view to retreive data from many tables.
My view calls a function to perform some complex calculations.



I would like to be able to call the function (or stored procedure) once
in my view,


and have it return multiple columns of data for my view.



I am sure this is possible, but I am not sure how to do it.



Any direction would be great.


Thanks for your help,
Received on Tue Aug 15 2006 - 09:21:44 CDT












Original text of this message













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