Re: Defining PL/SQL Cursors in Designor 2000

You can create cursor as Modules in Des2K.

1. Create a module.
2. For Language enter PL/SQL
3. For type enter cursor
4. Enter the select statement in the PL/SQL block. (Without the CURSOR <name> IS )
5. Include your CURSOR in whatever procedure, function or package you want.

Greetings,

Maarten

Shaun Mallory <smallory_at_ehv.sc.philips.com> wrote in article <35B5DD15.E37A65E7_at_ehv.sc.philips.com>...
> Hello All,
>
> I cannot seem to enter a cursor definition into the Modules portion of
> Designor 2000. I am able to enter variables in the Program Data section
> and I presume that a cursor is defined in the Datastructures section.
> All I can do in this section is enter the name of the cursor but not the
> SQL statement. Can any one tell me where I enter the cursor definition?
>
> Shaun Mallory
> smallory_at_ehv.sc.philips.com
>
>
Received on Thu Jul 23 1998 - 11:13:44 CEST