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: PL-SQL: Cursor definition with additional parameter ? reason/meaning ?

Re: PL-SQL: Cursor definition with additional parameter ? reason/meaning ?

From: tony_becky_mikey_verizon_news <Xyz_at_pdq.com>
Date: Thu, 22 Feb 2007 22:19:00 -0600
Message-ID: <45de6b39$0$24762$4c368faf@roadrunner.com>


The parameter is used in the select statement that builds the cursor.. Think of it as a placeholder that passes through the parameter to the select statement building the cursor..

"Werner Mueller" <Werner2_at_mail.org> wrote in message news:45de0724$0$6404$9b4e6d93_at_newsspool2.arcor-online.net...
>I learned that a cursor definition in PL-SQL follows the schema:
>
> Curosr mycurosr is ...
>
> Now I found a couple of sample where the cursor definition is like
>
> Cursor mycursor (somevar VARCHAR2) is ....
>
> What does that parameter/variable defintion mean ?
> Sometimes even more 2 or 3 additional vars are defiend
>
> How can I use this variable.
> May I get an example on how to apply such a parameter.
>
> Werner
>
>



I am using the free version of SPAMfighter for private users. It has removed 101 spam emails to date.
Paying users do not have this message in their emails. Try SPAMfighter for free now! Received on Thu Feb 22 2007 - 22:19:00 CST

Original text of this message

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