Dynamicly build Cursor

From: S van Hoof <stephan_at_hoof.nl>
Date: Mon, 8 Jan 2001 10:28:09 +0100
Message-ID: <93c163$rg6$1@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:28:09 CST