Re: PL/SQL - Use bind variable in "from <table>" query
- From: Lyndon Tiu <ltiu@xxxxxxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 31 Jan 2005 21:09:13 -0800
On January 31, 2005 09:05 pm, Lyndon Tiu wrote:
> The code:
>
> ------------
> declare:
>
> v_table_name varchar2
>
> v_value varchar2
>
> begin
>
> select table_name into v_table_name from lookup_table;
>
> select value into v_value from :v_table_name;
>
Slight typo:
select value into v_value from :v_table_name where pk = 1;
PL/SQL compiler complains about bad bind variable :v_table_name.
Thanks.
--
Lyndon Tiu
--
//www.freelists.org/webpage/oracle-l
Other related posts:
