Re: DBMS_SQL Dynamically creating views.

Aren't you missing the bind and fetch phases ? Read any documentation for Dynamic SQL stages.

Hope this helps.
Srinivas.Chikka

>What's wrong here?
>(END_REF is irrelevant. )
>
>CREATE OR REPLACE PROCEDURE TEST_DBMS_SQL
>(START_REF IN VARCHAR,
>END_REF IN VARCHAR ) IS
>CURSOR_NAME INTEGER;
>ROWS_PROCESSED INTEGER;
>AIR_COUNT INTEGER;
>SQL_STRING VARCHAR(240);
>BEGIN
>
>CURSOR_NAME := DBMS_SQL.OPEN_CURSOR;
>SQL_STRING := 'SELECT COUNT(*) INTO :AIR_COUNT FROM ' || START_REF ;
>
>DBMS_SQL.PARSE (CURSOR_NAME, SQL_STRING, DBMS_SQL.V7);
>ROWS_PROCESSED := DBMS_SQL.EXECUTE(CURSOR_NAME);
>
>DBMS_OUTPUT.PUT_LINE ('START REF IS: ' || START_REF );
>DBMS_OUTPUT.PUT_LINE ('ROWS PROCESSED IS: ' || ROWS_PROCESSED );
>DBMS_OUTPUT.PUT_LINE ('AIR_COUNT IS: ' || AIR_COUNT );
>
>DBMS_SQL.CLOSE_CURSOR( CURSOR_NAME );
>END TEST_DBMS_SQL;
>
Received on Thu Aug 27 1998 - 00:00:00 CEST