PL/SQL statement in Developer/Form have problem

From: rubbish <rubbish_at_ms55.url.com.tw>
Date: 11 Oct 2001 01:20:31 -0700
Message-ID: <f84e6132.0110110020.26d67697_at_posting.google.com>



I creative Developer2000/Form that function is "select table before show all record."
[Quoted] 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; Received on Thu Oct 11 2001 - 10:20:31 CEST

Original text of this message