Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Simple Use of dbms_scheduler

Simple Use of dbms_scheduler

From: Ed <ed_at_mail.com>
Date: Wed, 21 Feb 2007 12:57:45 -0500
Message-ID: <12tp20q2arb1j2b@corp.supernews.com>


I just want a stored proc process to run in a separate session, immediately no scheduling

I could use dbms_job to spawn it.

How do I do it with dbms_scheduler ?
How do I spawn "test" ?

CREATE OR REPLACE PACKAGE BODY testpkg IS

PROCEDURE test(p_alpha IN NUMBER DEFAULT 4321) IS BEGIN
    null;
END; END; thanks
10gr2 Received on Wed Feb 21 2007 - 11:57:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US