Designer 2000 - Cursor Creation.

[Quoted] I have a PL/SQL procedure defined in Designer 2000 and want to use a cursor in the procedure.

I created a datastructure in the RON of type PL/SQL Cursor and added datastructure items refering to the table and columns I want in the cursor. The problem is that when I generate the DDL the select portion of the cursor is not generated. All I get in the code is something
like this

     TYPE my_cursor IS CURSOR

I kinda expected there to be a select statement included in this type definition.
Anyone else run into this problem? Other funny thing is that in the help for
datastructures it only list PL/SQL Record and PL/SQL as the only valid selections for type of datasturcture. Have they not fully implemented the creation
of cursors yet?

TIA
clarence.johnson_at_trw.com Received on Mon Sep 15 1997 - 00:00:00 CEST