In article <1165422900.197585_at_bubbleator.drizzle.com>, DA Morgan says...
> > Unless I am being very stupid (and perhaps I am!) I had thought I might
> > be able to define a variable (e.g. my_var) and associate it with a
> > "type" that could match the output of this select statement below.
> >
> >
> > How should I define my_var in order to be able to achieve this?
> >
> > thanks for any input
>
> You can't necessarily use INTO my_var. How many records will be returned?
>
> If more than one you need to use the OPEN REFCURSOR FOR syntax.
>
Only one - always - so should I be able to use the "into my_var" format?
--
jeremy
Received on Wed Dec 06 2006 - 10:37:43 CST
