Jeremy wrote:
> 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?
Yes.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Dec 06 2006 - 11:04:09 CST
