-
dbms_job.submit
can you use dbms_job package to schedule to run a package???
I think dbms_job only can submit a procedure, but what if I have a package????
thanks
-
-
you can run a procedure inside a package with dbms_job, if that's what you mean.
-
slimdave,
right, I have to procedure inside the package and I need to schedule to run the this package
-
declare
job# number;
begin
dbms_job.submit
(
job#,
'begin my_package.my_procedure;end;'
);
end;
... with whatever other dbms_job.submit parameters you need
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|