Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL-SQL: Cursor definition with additional parameter ? reason/meaning ?
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
>
>