4 Replies Latest reply: Dec 4, 2012 1:24 PM by 977953 RSS

    Procedure not showing up when I create 'Form on a procedure'

    977953
      I'm building an application based on an Oracle guide for 'Adventure Travel', the guide says to create this 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;

      I've added that procedure and I can see it in the object browser, but when I try to create a new 'form on a procedure', the procedure doesn't show up. Also, when I look at the procedure in the object browser, under 'errors' it says "Line: 6     Position: 3     PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: ; current delete exists prior "

      Although I am assured that the code has the correct syntax, I've also tried adding the / character after END; but to no avail. Any help would be most appreciated