11 Replies Latest reply on Jun 17, 2019 2:57 PM by Mike Kutz

    Quick way to debug PL/SQL code which is having 30000 lines

    3722045

      Hi Experts,

       

       

      A package is having aroung 30000 lines of code.

      Which is internally calling lot of other packages and procedures.

       

       

      The package is throwing error.

       

       

      Could you please help me how to debug quickly in which package (or) procedure (or) line error is occuring.

       

       

      I am posting sample code of it.

       

       

      create or replace package body custpack1 as

      vv_version varchar2(300) :='NEW VERSION';

       

       

      function varr return varchar2 is

      begin

      return vv_version;

      end varr;

       

       

      eventpack.proc1;

       

       

      procedure cust_check1;

       

       

      is

       

       

          begin

      exception

      end;

          

       

       

      procedure cust_check2;

       

       

      is

       

       

          begin

      exception

      end;

      procedure cust_check3

           is

      begin

       

       

      prd_custPack.infPrc1;

      begin

      prd_custPack.infPrc2;

      exception

      end;

      end;

      end;

       

       

       

       

      Thanks in advance.