scheduling a PL/SQL proc / function

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Peter Jenny
    #1

    scheduling a PL/SQL proc / function

    Hi NG

    is it possible to schedule a PL/SQL proc / function "inside" ORACLE ?

    Thanks
    Peter

    Tags: None
    • Mark C. Stock
      #2
      Re: scheduling a PL/SQL proc / function

      lookup DBMS_JOBS

      is this a project or are you studying for a test?
      "Peter Jenny" <Peter.Jenny@ce des.comwrote in message news:c0vdg9$q34 $1@rex.ip-plus.net...
      Hi NG

      is it possible to schedule a PL/SQL proc / function "inside" ORACLE ?

      Thanks
      Peter

        Comment

        • sybrandb@yahoo.com
          #3
          Re: scheduling a PL/SQL proc / function

          "Peter Jenny" <Peter.Jenny@ce des.comwrote in message news:<c0vdg9$q3 4$1@rex.ip-plus.net>...
          Hi NG
          >
          is it possible to schedule a PL/SQL proc / function "inside" ORACLE ?
          >
          Thanks
          Peter
          >
          --
          yes.
          Please refer to the documentation on the dbms_job package

          Sybrand Bakker
          Senior Oracle DBA

            Comment

            • Mark D Powell
              #4
              Re: scheduling a PL/SQL proc / function

              "Peter Jenny" <Peter.Jenny@ce des.comwrote in message news:<c0vdg9$q3 4$1@rex.ip-plus.net>...
              Hi NG
              >
              is it possible to schedule a PL/SQL proc / function "inside" ORACLE ?
              >
              Thanks
              Peter
              >
              --
              See the Oracle Supplied PL/SQL Packages manual for DBMS_JOB. This is
              an internal job scheduler package.

              Also when a newsgroup has sub-groups you should generally post in the
              appropriate sub-group and not the group.

              HTH -- Mark D Powell --

                Comment

                • Seamus Ma' Cleriec
                  #5
                  Re: scheduling a PL/SQL proc / function

                  "Peter Jenny" <Peter.Jenny@ce des.comwrote in message news:<c0vdg9$q3 4$1@rex.ip-plus.net>...
                  Hi NG
                  >
                  is it possible to schedule a PL/SQL proc / function "inside" ORACLE ?
                  >
                  Thanks
                  Peter
                  >
                  --
                  Look into the dbms_job package

                    Comment

                    • Hans Forbrich
                      #6
                      Re: scheduling a PL/SQL proc / function

                      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

                        Comment

                        Previous template Next
                        Working...