Re: dynamic SQL with dbms_sql, example?

> has anybody an example-code
> for such a procedure,
> which work?

does this help?

...

vCursorID INTEGER;
vSelectStmt VARCHAR2;
vDummy INTEGER;

BEGIN vCursorID := DBMS_SQL.OPEN_CURSOR;
vSelectStmt := 'SELECT [var] FROM [var]';

DBMS_SQL.PARSE (vCursorID, vSelectStmt, DBMS_SQL.V7);

DBMS_SQL.DEFINE_COLUMN (vCursorID, 1, [var]);

LOOP
    DBMS_SQL.COLUMN_VALUE(vCursorID, 1, [var]);     IF DBMS_SQL.FETCH_ROWS(vCursorID) = 0 THEN

        EXIT;
    END IF;
END LOOP;
DBMS_SQL.CLOSE_CURSOR(vCursorID); Received on Wed May 12 1999 - 16:30:46 CDT