Query problem

Hi,

We are trying to implement a logic that have following steps:

begin
Look for existence of table
If is exists run query that uses that table else skip this block and run query that uses other table end

But Oracle compiler don't like it since it check for existence of all the tables in a block at compile time and throw error: "table does not exists"

Then we tried to use execute immediate but that have a limit of 4096 characters for query.

Is there workaround for this issue (except pre-creating tables)?

Thanks
--Harvinder

--

http://www.freelists.org/webpage/oracle-l Received on Fri Nov 03 2006 - 07:14:02 CST