Hi All,

I need to write a procedure or function that will query 3 seperate
tables. The tables small and just hold item #'s and descriptions.

After querying the tables, I need to return the results to the calling
PHP script. I'm not `100% sure how to do this. Should I just create
3 VARRYS's or Collections? And, do I just declare them as an OUT
parameter? Or is there more to it?

Thanks in advance

amerar@iwc.net wrote:
> Hi All,
>
> I need to write a procedure or function that will query 3 seperate
> tables. The tables small and just hold item #'s and descriptions.
>
> After querying the tables, I need to return the results to the calling
> PHP script. I'm not `100% sure how to do this. Should I just create
> 3 VARRYS's or Collections? And, do I just declare them as an OUT
> parameter? Or is there more to it?
>
> Thanks in advance

Oracle version?
Table DDL?
SELECT statement DML?

Guessing on our part will likely be even less helpful.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org