Re: PLSQL: how to test if a table exists?

"NoName" wanted this group to know...
> Hello,
>
> in a PLSQL script, I want to execute code only if a certain table
exists.
> A pseudo-solution could be:
>
> declare
> cursor c1 is select * from notable;
> begin
> open c1;
> if c1%ISOPEN then
> -- statements to execute if table exists
> end if;
> end;
>
> Obviously, the above code is not correct, first of all the script
throws an
> execption if "notable" doesn't exist.
> Any workaround?
>
> Thank you
>

Hi Nameless,

you could check the existence with a query against the data dictionary.
Then handle the result / error.

hth,
Guido Received on Thu Dec 04 2003 - 05:40:51 CST