Re: returning three select statements from a function

Why don't you use some output parameters? Then you don't have concatenate at all.

In article <OGC15.957$Ko2.28348_at_wormhole.dimensional.com>,   "S Bunker" <bunkers_at_bigfoot.com> wrote:
> You could proabbly concatenate the results for all three selects into
 a big
> varchar2 variable and add CHR(10) (or 12) linefeeds and then return a
 single
> formatted (w/ linefeeds) varchar2 at the function output. Just a
 guess.
>
> "SP" <spant1_at_aol.com> wrote in message
> news:uYA15.1321$Qf6.51350_at_nuq-read.news.verio.net...
> > I want to return the output from three diiferent select statements
 (by a
> > function) like this:
> > name date issueNumber
> > ----- ---------- ----------- -------
> > (0 row(s) affected)
> >
> > r_date prodID
> > ---------- ----------- -------
> > (0 row(s) affected)
> >
> > date issueNumber
> > ---------- -----------
> > (0 row(s) affected)
> >
> > I was using ref cursor to return a single select statement. Is it
 possible
> > to return all three from a single function. I would appreciate your
 input.
> >
> > SP
> >
> >
> >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jun 14 2000 - 00:00:00 CDT