Dynamic SQL with DBMS_SQL cursor

hi,

            i need to know how to assign to a cursor variable a multi row query result created by DBMS_SQL dynamic SQL.
My code :             

    	    cur := DBMS_SQL.OPEN_CURSOR;
	    DBMS_SQL.PARSE(cur, sqlString, DBMS_SQL.NATIVE);
	    rc := DBMS_SQL.EXECUTE(cur);
	    DBMS_SQL.CLOSE_CURSOR(cur);

cur and rc are Integer Variable, sqlString is the sql query i need to assign result to a REF CURSOR variable type.

Thanks Received on Mon Jan 14 2002 - 05:03:16 CST