Re: Batch File + SQLPlus commands

Just to clear up the obvious misunderstanding, the logon info, arguments etc. were for illustrative purposes only!!!!

Mark Day.

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1078242337.534009_at_yasure...
> 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)
>
Received on Tue Mar 02 2004 - 10:35:37 CST