Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Simple question ...

Re: Simple question ...

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 6 Aug 2004 19:21:24 +0200
Message-ID: <4113bd8f$0$7784$626a14ce@news.free.fr>

"Ernest Morariu" <ernest_at_gesora.com> a écrit dans le message de news:cf075p$ee0$1_at_balena.cs.interbusiness.it...
> Michel,
>
> Many thanks for the links. I've already put them in my "Favorites".
>
> I knew I can use cursors for getting the same result(without relying on
> exceptions).
> The "SELECT INTO myVar" seemd to me more nice, but
> now I know that I shoud use it just when it works without generating
> exceptions in 99,9% of cases.
>
>
> ernest
>
>

Using "select ...", you use an implicit cursor and you can get its attributes with the keyword SQL as SQL%NOTFOUND...

--
Regards
Michel Cadot
Received on Fri Aug 06 2004 - 12:21:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US