Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL !
Only other way is to code an exception around your select.
Triggers fire exclusively on 'before'/'after'/'in stead of' row or table
events, so it's impossible to do this unless you actually do the events
which makes the trigger fire
"Rahul" <rahul_europe_at_yahoo.com> wrote in message
news:923a99a4.0108201211.f59a523_at_posting.google.com...
> hi there:
>
> I was wondering if you have the answer of following two questions:
>
> a. Inside PL/SQL block, how to check that a particular table does not
> exist.
>
> I know this one,but there will be some other better ways as well, so
> do you know some of them?
>
> if(rad_cursor2%NOTFOUND) then
> dbms_output.put_line('the table is emply');
>
>
> b. how to call a trigger block from PL/SQL block.
>
>
> regards,
> rahul
Received on Mon Aug 20 2001 - 16:27:00 CDT