-
Dbms_job Packages Errors
Hi all,
I have package A and in B,C is the procedure inside of the package.
I have never done schedule a package in dbms_jobs before, below is what I have in mind
var x number
begin
dbms_job.submit(:x, 'begin A.B; end;',TRUNC(sysdate)+22/24, 'TRUNC(sysdate)+1+22/24');
commit;
end;
/
it doens't work b/c I think I don't have the second proc
thanks,
-
define 'doesnt work'
and also you dont need the begin and end, just a.b
-
where can I put the C procedure??? as you see, I only have A for package and B for the first procedure, where can I put the C ???
-
what about c? what do you want to do with it
-
since the package A had B,C procedure. I figured I need to have B,C procedure on dbms_job, right??? I don't know how.
-
what?????? that makes no sense, just run what you want to run
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
|