harvinder76_at_gmail.com wrote:
> "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
- Please do not top post. Scroll to the bottom to reply.
- Using a technique that will permanently decrease scalability and
performance is a solution of last resort.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Nov 03 2006 - 10:49:26 CST