Query problem
- From: "Harvinder Singh" <Harvinder.Singh@xxxxxxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 3 Nov 2006 08:14:02 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
