Re: PL/SQL cursor status without fetching???

In article <3D7947F1.F254D04D_at_oracle.com>, Martin says...
>
>This is a multi-part message in MIME format.
>--------------139C138F58951CA6FE7B6C06
>Content-Type: text/plain; charset=UTF-8
>Content-Transfer-Encoding: 7bit
>
>Thomas Kyte wrote:
>
>> In article <alagg9$1oqfm3$1_at_ID-114658.news.dfncis.de>, "Giovanni says...
>> [snip]
>>I sure hope you know ALL ABOUT function based indexes, or we have another java
>>program going down the tubes real fast (user VARCHAR2, skip the trim, whats up
>> with upper(zip_code)?).....
>> [snip]
>
>Upper(zip_code) would only make sense if there may be addresses outside USA e.g.
>Canada, UK which have alphanumeric post codes. Which makes me wonder why the
>WHERE
>clause makes no reference to country code

You know, I'm always forgetting about those other places... (only kidding)..

btw, if they do this upper(trim()) thing, read about FUNCTION BASED INDEXES (please)

>
>--------------139C138F58951CA6FE7B6C06
>Content-Type: text/x-vcard; charset=UTF-8;
> name="martin.doherty.vcf"
>Content-Transfer-Encoding: 7bit
>Content-Description: Card for Martin Doherty
>Content-Disposition: attachment;
> filename="martin.doherty.vcf"
>
>begin:vcard
>n:Doherty;Martin
>tel;work:+1 650 506-8398
>x-mozilla-html:FALSE
>url:http://industries.oraclecorp.com
>org:Oracle Corporation;Industry Solutions
>version:2.1
>email;internet:martin.doherty_at_oracle.com
>title:Senior Software Specialist
>adr;quoted-printable:;;Mail Stop C3038=0D=0A10 Twin Dolphin Dr=0D=0A;Redwood
>Shores;CA;94065;USA
>fn:Martin Doherty
>end:vcard
>
>--------------139C138F58951CA6FE7B6C06--
>

--
Thomas Kyte (tkyte@oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp