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_at_yahoo.net>
Date: Wed, 18 Feb 2004 16:39:56 GMT
Message-ID: <4033955B.1FC9427E_at_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 - 17:39:56 CET