Re: How to exit a procedure if condition is true

> WHY so complex?????

I snipped out quite a bit of code before posting - it actually does much more than I showed here.
Thanks!
D.

> create or replace procedure proc_cleanup
> is
> begin
>
> INSERT INTO TABLE2(col1,col2)
> SELECT id_no, quantity
> FROM table1
> WHERE id_no IS NOT NULL;
>
> end proc_cleanup;
>
> Isn't it better ??
>
> --
> Noel.
Received on Wed May 07 2003 - 13:11:27 CDT