Re: Query problem (Need workaround)

harvinde..._at_gmail.com wrote:
> 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

Issue query against table_1
If you get an error, issue query against table_2. Received on Fri Nov 03 2006 - 07:26:56 CST