Re: Dynamicly build Cursor

You'll need Native Dynamic SQL as available in Oracle 8i. In Oracle 8.0 you have to resolve this by using the dbms_sql package. As the terminal release for 8i has been announced (and 8.0.6 is already the terminal release for 8.0) I would try to upgrade asap.
BTW, you are two major releases behind with Forms, you may want to check whether Forms 5 is still supported.

Hth,

Sybrand Bakker, Oracle DBA

"S van Hoof" <stephan_at_hoof.nl> wrote in message news:93c14p$ra2$1_at_news1.xs4all.nl...
> Hi,
>
> Forms5, Oracle 8:
>
> I would like to have a cursor variabele which is dynmic build, let say by
> means of an in parameter 'cur_sql'.
>
> NOW I have it static like:
> PROCEDURE SELECT_VAL() IS
> BEGIN
> ...
> For R in (
> SELECT field FROM table WHERE condition)
> LOOP
> ....
> END LOOP;
> ...
> END
>
> What I would like to have in certain way:
> PROCEDURE SELECT_VAL(cur_sql IN varchar2) IS
> BEGIN
> ...
> For R in (
> cur_sql)
> LOOP
> ....
> ....
> END LOOP;
> ...
> END;
> Where cur_sql='SELECT field FROM table WHERE condition'
>
> Is this possible?????
>
>
>
>
Received on Mon Jan 08 2001 - 03:57:02 CST