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.
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