Re: Passing lists to a procedure

From: <paulwragg2323_at_hotmail.com>
Date: 30 Jan 2007 08:57:24 -0800
Message-ID: <1170176244.014662.92350@p10g2000cwp.googlegroups.com>

Finally, I have now seen where I was going wrong!! Just changing :

	AND UPPER(COLUMN_NAME) NOT LIKE 'SYS_%'
	AND TABLE_NAME IN (strTables)
to:
	AND UPPER(COLUMN_NAME) NOT LIKE 'SYS_%'
	AND TABLE_NAME IN (SELECT column_value
			  FROM TABLE( strTables ))

is what I required. I really thought I had read through everything fully. Apologies for wasting your time as I really should have spotted that this was the problem.

Many Thanks for the help!!

Paul Received on Tue Jan 30 2007 - 10:57:24 CST