Re: scheduling a PL/SQL proc / function

From: Hans Forbrich <hforbric_at_yahoo.net>
Date: Wed, 18 Feb 2004 16:39:56 GMT
Message-ID: <4033955B.1FC9427E@yahoo.net>

> Peter Jenny wrote:
>
> Hi NG
>
> is it possible to schedule a PL/SQL proc / function "inside" ORACLE ?
>
> Thanks
> Peter

Oracle provides a LOT of related capabilities. As others have mentioned, you want to start with DBMS_JOB. For more advanced capabilities, you want to wander around their Advanced Queueing, Workflow and Business events.

<rant>
This is ALL documented in the online documentation about included packages. Go to http://docs.oracle.com, dig into the docs for your version, use the 'list all books' capability and just spend 3-5 minutes looking at the titles. It's well worth you time (and ours) to get familiar with what's available.
<\rant>
/Hans Received on Wed Feb 18 2004 - 10:39:56 CST