Jan,
> > How do I drop a temporary table ( or for that matter a sequence) only
> > if it exists or create them if they donot exist ? I want to do this
> > to avoid any errors
>
> I wonder what type of application cannot remember if it created a temp
> object or not during the lifetime of it's database connection.
A real one, Jan.
This sort of test is particularly necessary for Exception handling routines.
One wants the exception handler to drop all temporary obejcts for a clean
slate, but since an exception has occurred, one cannot be sure which objects
were created successfully.
I've personally written several such routines.
--
-Josh BerkusAglio Database SolutionsSan Francisco