Re: PL/SQL - Use bind variable in "from <table>" query

From: Lyndon Tiu <ltiu@xxxxxxxxxxxxx>
To: Mladen Gogala <gogala@xxxxxxxxxxxxx>
Date: Mon, 31 Jan 2005 21:45:57 -0800

OK, I figured it out, you need to create the statement as a string first using 
the concat operator ||:   

begin

<... pl sql code ...>

        select_stmt :=  'select ' || v_record_type || ' from ' || 
v_table_view_name || ' where ' || v_record_pk_field_name || ' = ' || 
new.record_pk_field_name;

        execute immediate select_stmt into v_value;

<... more pl sql code ..>

end


Thanks.

--
Lyndon Tiu
--
http://www.freelists.org/webpage/oracle-l

References:

PL/SQL - Use bind variable in "from <table>" query
From: Lyndon Tiu

Re: PL/SQL - Use bind variable in "from <table>" query
From: Mladen Gogala

Re: PL/SQL - Use bind variable in "from <table>" query

Other related posts: