RE: substitute object name with bind variables

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Tue, 11 Jan 2005 15:13:59 -0500
Message-ID: <002401c4f81a$15ccadb0$2004a8c0@development.perceptron.com>

create or replace procedure testbind (v_id in number) as         

begin

            for tabname in (select table_name from user_tables where table_name like 'TAB%')

	loop
		execute immediate 'delete ' || tabname.table_name || '
where id=:b2' using v_id;
	end loop;

end;
/

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of geraldine_2_at_comcast.net
Sent: Tuesday, January 11, 2005 2:56 PM
To: oracle-l_at_freelists.org
Subject: substitute object name with bind variables

Is there a way to substitute object names as such table_name or view name with bind variables in the following sample code?

obviously this code does not run because I cannot substitute :b1 with tabname.table_name.

suggestions?

create or replace procedure testbind (v_id in number) as         

begin

            for tabname in (select table_name from user_tables where table_name like 'TAB%')

	loop
		execute immediate 'delete :b1 where id=:b2' using
tabname.table_name,v_id;
	end loop;

end;
/

thanks.

geraldine

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


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

Received on Tue Jan 11 2005 - 14:15:04 CST