Re: Query problem (Need workaround)

"Perhaps you could use a variable for the tablename in your query"

variable name requires dynamic sql and limit is 4096 characters so it is not an option
unless there is way to use variable as table_name in query without dynamic sql

On Nov 3, 11:01 am, "gazzag" <gar..._at_jamms.org> wrote:
> harvinde..._at_gmail.com wrote:
> > We are checking the user_tables view for existence of table, but the
> > error is not during run time but compile time.My apologies, I misread your post.
>
> Perhaps you could use a variable for the tablename in your query. This
> variable could be assigned depending on the presence of the table at
> runtime, so should allow compilation.
>
> Also, please do not top-post. Please post your reply *beneath* the
> text that you are quoting as this makes threads more readable to the
> group.
>
> HTH
>
> -g
Received on Fri Nov 03 2006 - 10:37:37 CST