Creating a cursor from a VARCHAR2

Hi,

I have a cursor like.....

CURSOR cur_get_info IS

    SELECT * FROM .........; However, I'd like to create the cursor so that instead of typing in the SELECT statement, it comes from a string. i.e.

    CURSOR cur_get_info IS

         [my VARCHAR2];

Any advice would be great.

Thanks,
Allan Martin Received on Wed Sep 19 2001 - 03:32:30 CDT