| Automatic execute a store procedure. [message #76484] |
Sun, 25 August 2002 20:35  |
Sock Wai
Messages: 1
Registered: August 2002
|
Junior Member |
|
|
hi,
I am trying to execute a store procedure automatically and need help.
I have a store procedure which require to run on each monday. Each time I run the store procedure I need to manually run it, is there anyway that oracle can automatically run the store procedure.
I am very new to oracle. Thank you for your help.
|
|
|
|
| Re: Automatic execute a store procedure. [message #76514 is a reply to message #76484] |
Fri, 04 October 2002 17:08  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
In sqlplus:
set serveroutput on
declare
l_job number;
begin
dbms_job.submit( job => l_job,
what => 'your_procedure;',
next_date => sysdate,
interval => 'next_day(trunc(sysdate), 'MON') + 17/24 /* 5pm on Monday */' );
commit;
dbms_output.put_line( ' your job is # '|| l_job);
end;
/
select * from user_jobs;
Use dbms_job.remove to remove a job.
|
|
|
|
| store procedure. [message #76604 is a reply to message #76484] |
Wed, 29 January 2003 22:53 |
Daniel
Messages: 47
Registered: February 2000
|
Member |
|
|
Prompts the user for a number. Use a loop to verifies user input.
Using the value x inputted, loop x times. Use x as the radius. Calculate the area of a circle with radius x.
Print the radius and area for each time through the second loop.
Turn in print out of code, and print screen with run of script
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
