Running Oracle 11g SQL*plus script generates ORA-06650 "end-of-file"

[GoogleCodeExporter]

I have the following SQL*Plus script:

DECLARE
  -- --------------------------------------------------------------------------
  -- Proc to do inserts into AOR Table
  -- --------------------------------------------------------------------------
  PROCEDURE sync_aor (
            i_aor_id      casm_owner.aor.aor_id%TYPE
          , i_aor_name    casm_owner.aor.aor_name%TYPE
  ) IS
  BEGIN
      MERGE INTO casm_owner.aor        aor
            USING (SELECT i_aor_id    AS aor_id
                        , i_aor_name  AS aor_name
                     FROM dual) sq
               ON (sq.aor_id = aor.aor_id)
             WHEN MATCHED THEN
                  -- basically a dummy statement here.  Don't need to do
anything
                  -- if we have a match.  Just leave this as it is.
                  UPDATE SET aor.aor_name = sq.aor_name
             WHEN NOT MATCHED THEN
                  -- Record doesn't exists so add it to the table
                  INSERT (aor_id, aor_name, created_dt, created_by)
                    VALUES(sq.air_id, sq.aor_name, SYSTIMESTAMP, USER);
  END;
BEGIN
  --AOR's from the casm development client
  sync_aor('E85E6CEB1AF28590092FBADAAC4C8FB0','Work Flow Test');
END;
/


Somehow, the script fails when I try to run it using this utility.  It
thinks the semi-colon(;) at the end of the INSERT is not there.  Therefore
it generates the error:  

Caused by: java.sql.SQLException: ORA-06550: line 1, column 568:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the
following:

Original issue reported on code.google.com by globobla...@gmail.com on 28 Jan 2010 at 7:40