Re: rerunnable code

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Fri, 25 Apr 2003 16:13:03 GMT
Message-ID: <MPG.1912fe6b8e4dbe96989759@news.la.sbcglobal.net>

sunil_franklin_at_hotmail.com said...
> Any pointers on writing rerunnable pl/sql code (involves lots of dml and ddl
> statements) ?
>
> Thanks,
> Sunil.
>

Not sure what you're asking, but the following will rerun a pl/sql stored procedure:

begin
  loop
    do_stored_procedure(arguments);
  end loop;
end;

Since I doubt that's what you were asking, how about a few details?

-- 
/Karsten
DBA > retired > DBA

Received on Fri Apr 25 2003 - 11:13:03 CDT