public   int []  GetLengthWidth( int  Angle_Start,
                                  int  Angle_End,
                                  int  nArea,
                                  int  inDefectKey) {
        CallableStatement cstmt =  null ;
         int [] a =  new   int [ 2 ];
         try  {
            cstmt = getConnect.prepareCall("{call package1.procedure1(?,?,?,?,?,?)}");
            cstmt.setInt( 1 , Angle_Start);
            cstmt.setInt( 2 , Angle_End);
            cstmt.setInt( 3 , nArea);
            cstmt.setInt( 4 , inDefectKey);
            cstmt.registerOutParameter( 5 ,OracleTypes.INTEGER);
            cstmt.registerOutParameter( 6 ,OracleTypes.INTEGER);
            cstmt.execute();

            a[ 0 ] = cstmt.getInt( 5 );
            a[ 1 ] = cstmt.getInt( 6 );
        } catch (Exception e) {
            write(e, "GetLengthWidth");
        }
         return  a;
    }

  procedure procedure1(Angle_Start in number, 
                           Angle_End in number, 
                           nArea in number, 
                           inDefectKey in number, 
                           nLength out number, 
                           nWidth out number) is
    diam number;
  begin
       select TO_Number(e.ndiametr_ext) into diam
       from ias_defects d, ias_pipepoints p, ias_v_elemparts e
       where d.npipepointid = p.npipepointkey
       and p.npipeid = e.npipeid
       and d.ndefectkey = inDefectKey
       and p.ndistancereal between e.km_beg and e.km_end -  0 . 0000001 ;
       
       nWidth :=  sys.standard.abs(Angle_End - Angle_Start)* 2 * 3 . 14159 *diam/ 2 / 12 ;
       nLength := nArea* 1000000 /nWidth;
  end;