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

Home -> Community -> Usenet -> c.d.o.misc -> PL-SQL: Cursor definition with additional parameter ? reason/meaning ?

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

From: Werner Mueller <Werner2_at_mail.org>
Date: 22 Feb 2007 21:12:04 GMT
Message-ID: <45de0724$0$6404$9b4e6d93@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 Received on Thu Feb 22 2007 - 15:12:04 CST

Original text of this message

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