Re: cursor syntax question

From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Thu, 1 Oct 2009 07:25:35 -0700 (PDT)
Message-ID: <74a70d92-6a26-42a6-983c-182664f27107_at_u16g2000pru.googlegroups.com>

On Oct 1, 9:42 am, kes <abi..._at_gmail.com> wrote:
> 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

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 -- Received on Thu Oct 01 2009 - 09:25:35 CDT