package Analitic;

import java.io.IOException;
import java.math.BigDecimal;
import java.sql.Array;
import java.sql.DriverManager;
import java.sql.SQLException;

import oracle.jdbc.OracleConnection;
import oracle.sql.NUMBER;

public class Execute
{
  public static void Oracle(
                            Object              _this, 
                            String              _id_contract_sap[], 
                            NUMBER              _nbi[], 
                            Array               _span_row[],
                          //Array               _span_sms[]
                            PostgreSQLInt4Array _span_sms[]
                           ) 
  throws IOException, SQLException, ClassNotFoundException 
  {
    _nbi[0]                    = new NUMBER(new BigDecimal(120.56).doubleValue());
    BigDecimal span_row[]      = {new BigDecimal(120.00),new BigDecimal(130.00)};
    int        span_sms[]      = {220,230};
    PostgreSQLInt4Array list   = new PostgreSQLInt4Array(span_sms);
    _id_contract_sap[0]        = list.toString();
    if (_this == null) _span_row[0] = ((OracleConnection) DriverManager.getConnection("jdbc:default:connection")).createARRAY("FDNBI",span_row);
  //if (_this == null) _span_sms[0] = ((OracleConnection) DriverManager.getConnection("jdbc:default:connection")).createARRAY("FDNBI",span_sms);
    if (_this == null) _span_sms[0] = list;
  };
}

create or replace type fdNbi as table of number;
create or replace function fnMove(
                              my_this          in ref RCNBI,
                              id_contract_sap  in out Varchar2,
                              nbi              in out Number,
                              span_row         in out FDNBI,
                              span_sms         in out FDNBI
                                 ) return Varchar2 as
language java name 'Analitic.Execute.Oracle
                             (oracle.sql.REF,
                              java.lang.String[],
                              oracle.sql.NUMBER[],
                              java.sql.Array[],
                              Analitic.PostgreSQLInt4Array[]
                             ) return java.lang.String[]';
                             
begin
  declare
    s Varchar2(10);
    i integer:=10;
    id_contract_sap  Varchar2(14):='0123456789';
    nbi              Number;
    tbspan_row       fdNbi;
    tbspan_sms       fdNbi;
  begin
             s:= fnMove(null,
                        id_contract_sap,
                        nbi,
                        tbspan_row,
                        tbspan_sms
                       );
    dbms_output.put_line(id_contract_sap);
    dbms_output.put_line(nbi);
    dbms_output.put_line(tbspan_row(1));
    dbms_output.put_line(tbspan_row(2));
    dbms_output.put_line(tbspan_sms(1));
    dbms_output.put_line(tbspan_sms(2));
  end;  

end;