I've looked in Oracle PL/SQL 3rd Edition and searched psoug.org but I
was unable to determine:
CURSOR foo (vbar varchar2) IS
select *
from table_t t
where t.bar = vbar;

I get that vBar is a varchar2, but what does it mean exactly? If you
could send me a pointer to any documentation this would be greatly
appreciated. This code was found in Oracle 10.2

Best,
Alex

~~~~
http://www.lifesabirch.org

On Thu, 1 Oct 2009 06:42:29 -0700 (PDT), kes <abirch (AT) gmail (DOT) com> wrote:


http://www.psoug.org/reference/datatypes.html

--
--
Sybrand Bakker
Senior Oracle DBA

On Oct 1, 9:42*am, kes <abi... (AT) gmail (DOT) com> wrote:
Alex, while Sybrand gave you a link to data type information posted
the same site you were found your cursor reference on I though you
might want to also reference the online official Oracle
documentation. Here is the site url: http://tahiti.oracle.com

You can find cursors in the PL/SQL manual and data types are defined
in both the Concepts and Application Developers Guide - Fundamentals
manuals.

HTH -- Mark D Powell --

D'oh the keyword that I was looking for was parameterized cursor (I
came up with this phrase when replying back). Google solved this one
for me. Oddly enough this isn't covered at psoug.org (er at least the
search doesn't return anything).

Thanks for your time,
Alex

On 10/01/2009 04:25 PM, Mark D Powell wrote:
I'd like to add that often no explicit cursor declaration is necessary, e.g.

http://download.oracle.com/docs/cd/B...htm#sthref1360

Kind regards

robert

--
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/

On Oct 1, 7:37*am, Alex Birch <abi... (AT) gmail (DOT) com> wrote:
The more updated link is http://www.morganslibrary.com/

There is a contact link on there if you have constructive suggestions.

jg
--
@home.com is bogus.
http://torrentfreak.com/retailer-mus...victim-090914/

Robert Klemme schreef:
That's in cursor-for loops only. And according to some aces cursor-for
loops are never necessary as well.

Shakespeare