Stored PL/SQL procedure with no parameters compiles with error.
I have a simple stored procedure that has no parameters. I'm getting an error in the compile, but I don't see what is wrong with the syntax? SQL> CREATE or REPLACE PROCEDURE xxbs_exch_newday () IS
2 --
3 BEGIN
4 --
5 UPDATE xxbs_process_table
6 set status_now = 'NEW DAY',
7 todays_date = sysdate
where process_name = 'Exchrate Load and Recovery';
8 9 --
10 COMMIT;
--
11 12 END xxbs_exch_initialize;
13 /
Warning: Procedure created with compilation errors.
SQL> show err
Errors for PROCEDURE XXBS_EXCH_NEWDAY:
LINE/COL ERROR
-------- -----------------------------------------------------------------
1/29 PLS-00103: Encountered the symbol ")" when expecting one of the
following:
<an identifier> <a double-quoted delimited-identifier>