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.
>
>

Drop the execute:
  begin
   mms_pps_comm.New_Row_In_OrdersFromPPS;   end;
commit;

execute (or exec for short) is the sql*plus equivalent of a begin before, and an end; after the statement, or: exec mms_pps_comm.New_Row_In_OrdersFromPPS; is equal to:
begin mms_pps_comm.New_Row_In_OrdersFromPPS; end;

-- 

Regards,
Frank van Bortel