Re: PL/SQL statement in Developer/Form have problem

> Can I use value in sql statement??? "like select &&col_val from
> &&tab_val"
> The code success in sql/plus but failed in form.
> --------------------------------------------------------------
>
> DECLARE
> V_COL VARCHAR2(30) := :TEMP_COLUMNS.COL_NAME;
> V_TAB VARCHAR2(30) := :TEMP_TABLE.TABLE_NAME;
>
> BEGIN
> OPEN CU_TEST;
> LOOP
> EXIT WHEN CU_TEST%NOTFOUND;
> FETCH CU_TEST INTO :TEMP_COLUMNS.COL_NAME;
> V_COL := :TEMP_COLUMNS.COL_NAME;
> V_TAB := :TEMP_TABLE.TABLE_NAME;
> SELECT &&V_COL FROM &&V_TAB;
> NEXT_RECORD;
> END LOOP;
> CLOSE CU_TEST;
> END;
You can't do this in Forms. You can use DBMS_SQL to perform dynamic queries but you'll probably have to encapsulate it inside a database package as a 'service' as you can't reference package constants, types etc from within Forms. Received on Wed Oct 17 2001 - 22:35:22 CEST