0

multiple_pkg_3.sub_proc_insert insert the data into table person_name. When compiling, ORA-00942: table or view does not exist is shown in the select statement.

   PROCEDURE chk_pkg_1 IS
        p_name VARCHAR2(25);
        exp_id NUMBER;
   BEGIN
        i11137.multiple_pkg_3.sub_proc_insert(v_name);
        SELECT id INTO exp_id FROM i11137.person_name WHERE name = v_name;
        ut.expect(exp_id).to_equal(act_id);
   END chk_pkg_1;          

The select statement works outside the procedure.

Success Shrestha
  • 433
  • 1
  • 4
  • 19

0 Answers0