5 Replies Latest reply: Dec 4, 2012 12:54 PM by 977953 RSS

    “PLS-00103: Encountered the symbol ”end-of-file“

    977953
      I'm following this Oracle guide called 'Adventure Travel' to create an application, in the guide it says use this statement to add a procedure:

      CREATE OR REPLACE PROCEDURE
      add_country_for_activity(p_activity_num AT_COUNTRY_ACTIVITIES.activity_num%TYPE,p_country_id AT_COUNTRY_ACTIVITIES.country_id%TYPE)
      IS
      BEGIN
      INSERT INTO AT_COUNTRY_ACTIVITIES (country_id,activity_num) VALUES (p_country_id,p_activity_num);
      END;

      That is exactly how the code is in the guide, but when I view that procedure in the Object Browser of Apex, it says there is an error with the code - “PLS-00103: Encountered the symbol ”end-of-file“ when expecting one of the following: ;” Anyone see the error?