Easy-to-Answer Question from Newbie

From: Joe <jdog10001_at_hotmail.com>
Date: 3 Jan 2003 13:15:18 -0800
Message-ID: <f48de37.0301031315.46a148b9@posting.google.com>

Is there an easy way to correct this problem without hardcoding the value in the SELECT statement or passing the value in as a parameter?

declare
  query_table_name VARCHAR2(32) := 'SYS.V_$SESSION'; begin
  select * from query_table_name;
end;
/

---

ORA-06550: line 4, column 17:
PLS-00201: identifier 'QUERY_TABLE_NAME' must be declared
ORA-06550: line 4, column 3:

PL/SQL: SQL Statement ignored Received on Fri Jan 03 2003 - 15:15:18 CST