Home » Infrastructure » Unix » Re: Calling Oracle Procedures from Unix shell
Re: Calling Oracle Procedures from Unix shell [message #97434] Mon, 06 May 2002 22:47
Dina
Messages: 3
Registered: May 2002
Junior Member
try this..
variable jobnum NUMBER
BEGIN
dbms_job.submit:jobnum,'ACTUAL_PROD_SCH_PDI_PROC;,TRUNC(SYSDATE) + 12/24, 'trunc(sysdate) + 1 + 12/24');
COMMIT;
END;
/

Report message to a moderator

Previous Topic: Passing parms to FTP Script???
Next Topic: Q for HA oracle on sun cluster
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 01:12:19 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.