6 Replies Latest reply on Mar 27, 2017 12:16 PM by thatJeffSmith-Oracle

    debug

    don123

      The following code is part of a package.Trying to debug this.

      The function call is defined as string and the same is called in create_job procedure.

      The debugger (F7 button) is not stepping into the function defined inside string.

      How to debug the function using Oracle sql developer 4.0

       

      ==========================

      str := 'decare v number;'

        || 'begin

        a := package.function ('||var1||','||var2);

        end;';

       

      dbms_scheduler.create_job(

      job_name=>'xyz',

      job_type=>'PLSQL_BLOCK',

      job_action=>str,

      start_date=>systimestamp,

      enabled=>TRUE);

      =======================

       

      Thanks