7 Replies Latest reply on Nov 6, 2008 9:38 PM by Sandy310

    ORA 04067: not executed, Stored procedure "PUBLIC". Does not exist.

    Sandy310
      We are migrating forms from 6i to 10g. while running forms in our local
      it is working fine but when we run same form from Application server
      we get error ORA 04067: not executed, Stored procedure "PUBLIC". Does not exist.
      We have applied patch for BUG 5123798 but still it is not working.
      Note: We don’t have any procedure named PUBLIC.

      We have came to conclusion that problem is because of %rowtype and %type
      Forms with procedures which are having %rowtype as in,out parameter are not working. when we use insert/update instead of using %rowtype everything works fine. It’s kind of weird. Have some faced this problem.

      PROCEDURE insertbrs_ware_trans (
      p_brs_mack_trans_rec brs_waretran_trans%ROWTYPE
      )
      IS
      BEGIN


      I will really appreciate your help.


      Thanks
      Sandy