5 Replies Latest reply: Jan 6, 2014 11:09 AM by rp0428 RSS

    How to find out the line which caused the runtime error in a SP?

    user12240205

      We have a situation like this.

       

      We are consulting company doing consultancy services on Oracle technologies.

       

      One of our clients have PL/SQL stored package.

       

      We found out by debugging the Oracle Forms front-end application that

      error is generated by a procedure inside this package.

       

      Problem is that this procedure has over 6000 lines.

       

      How do we figure out the line which caused the error?

       

      We tried putting messages in between, but not have been successful.

       

      Any help would be greatly appreciate.