1 Reply Latest reply on Apr 30, 2013 7:50 PM by LuigiBai

    Not able debeg plsql code in sqldeveloper when calling HTP.P or HTF.P

    Reji
      Hi,
      My web application is developed on oracle 9i using mod_plsql.

      I am getting below error while I am trying to debug my code which contains many calls to HTP..P or HTF.P

      ORA-06502: PL/SQL: numeric or value error
      ORA-06512: at "SYS.OWA_UTIL", line 330
      ORA-06512: at "SYS.HTP", line 860
      ORA-06512: at "SYS.HTP", line 975
      ORA-06512: at "SYS.HTP", line 993
      ORA-06512: at "REJI.A1", line 9
      ORA-06512: at line 2
      Executing PL/SQL: CALL DBMS_DEBUG_JDWP.DISCONNECT()
      Process exited.
      Disconnecting from the database REJI.
      Debugger disconnected from database.

      Please advice me how to debug my code having calls to HTP..P or HTF.P to generate HTML
        • 1. Re: Not able debeg plsql code in sqldeveloper when calling HTP.P or HTF.P
          LuigiBai
          I have found the following to be helpful in 11g. It initializes the package OWA so you don't get the error message. In addition, you can see the output page when it's finished.

          It may work in 9i.

          DECLARE
          NAME_ARRAY OWA.VC_ARR;
          VALUE_ARRAY OWA.VC_ARR;
          NULL_ARRAY OWA.VC_ARR;
          BEGIN
          -- Modify the code to initialize the variable
          NAME_ARRAY(1) := 'parm1';
          -- Modify the code to initialize the variable
          VALUE_ARRAY(1) := 'value1';

          owa.init_cgi_env(NULL_ARRAY);
          pkg.method(NAME_ARRAY, VALUE_ARRAY);
          owa_util.showpage;
          END;

          Luigi Bai
          Rice University