Calling DataBase Package After Process Form Request in OAF

/*Code Written After Process Form Request*/

public void DemandCompilationProcess(OAPageContext pageContext, OAWebBean webBean, String p_docno)

 {

    try {   OAApplicationModule am = pageContext.getApplicationModule(webBean);

       // OAViewObject vh = (OAViewObject)am.findViewObject("bgtCompProcessVO1");

                  

          OADBTransaction txn = am.getOADBTransaction();

          CallableStatement cs = null;

          cs = txn.createCallableStatement("begin XXAA_PROCESS_PKG.XXAA_BGT_COMP_COMPILE (:1,:2); END;", 0);

          cs.setString(1, p_docno);

          cs.registerOutParameter(2, Types.VARCHAR);

          cs.execute();

         String  p_docno1 = cs.getString(2);

         System.out.println("Flag: " + p_docno1);

        // vh.executeQuery();

         am.invokeMethod("disablePVOtrue");

          throw new OAException("Document " + p_docno + " has been created.", (byte)3);

       

      } catch (SQLException sqle) {

          sqle.printStackTrace();

      } //End Catch

   

  }