Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query problem (Need workaround)
We are checking the user_tables view for existence of table, but the
error is not during run time but compile time.
On Nov 3, 9:02 am, "gazzag" <gar..._at_jamms.org> wrote:
> 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
> > --HarvinderCheck out the USER_TABLES view.
>
> HTH
>
> -g
Received on Fri Nov 03 2006 - 09:47:50 CST