Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Simple Use of dbms_scheduler
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
![]() |
![]() |