Re: Query problem (Need workaround)

harvinder76_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

Check out the USER_TABLES view.

HTH -g Received on Fri Nov 03 2006 - 08:02:38 CST