Re: Batch File + SQLPlus commands

Mark Day wrote:
> Hi All,
> Everyday I have to enter an sqlplus command from the sqlplus GUI and I would
> like to create a batch file that I could schedule to automate this. When I
> open the sqlplus GUI I always type 'EXECUTE
> mms_pps_comm.New_Row_In_OrdersFromPPS;' then 'COMMIT;' finally exiting from
> the GUI.
>
> I have created a batch that contains the line below:
> D:\oracle\ora80\BIN\PLUS80W.EXE system/MANAGER @PPS.sql
>
> My PPS.sql is:
> BEGIN
> EXECUTE mms_pps_comm.New_Row_In_OrdersFromPPS;
> END;
> /
> COMMIT
> /
> EXIT
>
> But this doesn't appear to be working. Can anbody give me an example of what
> I'm missing in my .sql file?
>
> Many Thanks.
> Mark Day.

I agree with Sybrand on all points. I'll even bet I could break into your system with the user-id SYS and the password CHANGE_ON_INSTALL.

For a demo of DBMS_JOB: http://www.psoug.org/reference/dbms_job.html

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)