Re: Designer 2000 - Cursor Creation.

Clarence Johnson wrote:
>
> 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

Hi!

I did not have the same problems as you, bad I found, that DES2K has not all feature, which could be possible. Act. I tried to find a way to use parameters for Forms-App., but there are also not support.

Regards
Jürgen Jung Received on Tue Sep 16 1997 - 00:00:00 CEST