package Analitic; 

import java.io.IOException;
import java.math.BigDecimal;
import java.math.MathContext;
import java.sql.SQLException;
import oracle.sql.NUMBER;

import java.sql.*;
import oracle.jdbc.*;

public class Nbi_Exe 
{
	public String id_contract_sap;
	public double total_price;
	public int    duration_fate;
	public double span_row[];

	public static void Oracle
		 (
		  String _id_contract_sap[], 
		  NUMBER _total_price[],
		  NUMBER _duration_fate[],
		  Array  _span_row[]
	     ) 
	throws IOException, SQLException, ClassNotFoundException 
	{
		String id_contract_sap    = _id_contract_sap[0]; 
		try 
		{
		BigDecimal total_price    = new BigDecimal(    _total_price[0].doubleValue(),MathContext.DECIMAL64); 
		int duration_fate         = 5;
		BigDecimal span_row[] =new BigDecimal[duration_fate];

		for (int i = 1; i <= duration_fate; i++) 
		{
			span_row[i-1] = new BigDecimal(i);
		}

		_duration_fate[0] = new NUMBER(duration_fate);
		_span_row[0]      = span_row[0];    
                // во внешний массив представленный в качестве параметра (тип Array) необходимо вернуть вновь созданный span_row 
	    if(false) 
	    {
	    	_span_row[0]=((OracleConnection) DriverManager.getConnection("jdbc:default:connection")).createARRAY("FDNBI",span_row);
	    }
		} catch (Exception E) 
		{
		   throw new IOException(E.getMessage()+" "+id_contract_sap);
		}
	}
    

	public Nbi_Exe(String _id_contract_sap, double _total_price)
    throws SQLException, IOException, ClassNotFoundException 
	{
		this.id_contract_sap=_id_contract_sap;
		this.total_price    =_total_price;
		
		String[] id_contract_sap1=new String[]{_id_contract_sap}; 
        NUMBER[] total_price1    =new NUMBER[]{new NUMBER(total_price)}; 
		NUMBER[] duration_fate1  =new NUMBER[1];
        Array[]  span_row1       =new Array[1];
        this.Oracle(id_contract_sap1, total_price1,duration_fate1, span_row1);
        this.duration_fate=duration_fate1[0].intValue();
        this.span_row            =new double[this.duration_fate];    
		for (int i = 1; i <= duration_fate; i++) 
		{
			this.span_row[i-1] = (double) span_row1[0];
                        из параметра Array span_row1, необходимо запись данные в поле класса, представленное в качестве массива 
		}
	}
}

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 

package Analitic; 

import java.io.IOException;
import java.math.BigDecimal;
import java.math.MathContext;
import java.sql.SQLException;
import oracle.sql.NUMBER;

import java.sql.*;
import oracle.jdbc.*;

public class Nbi_Exe 
{
	public String id_contract_sap;
	public double total_price;
	public int    duration_fate;
	public double span_row[];
	
	public static void Oracle(
			          Nbi_Exe _this,
                                  String _id_contract_sap[], 
		                  NUMBER _total_price[],
		                  NUMBER _duration_fate[],
		                  Array  _span_row[]
                                 ) 
        throws IOException, SQLException, ClassNotFoundException 
	{
		String id_contract_sap = _id_contract_sap[0]; 
		try 
		{
			BigDecimal total_price = new BigDecimal(_total_price[0].doubleValue(),MathContext.DECIMAL64); 
			int duration_fate      = 5;
			BigDecimal span_row[]  = new BigDecimal[duration_fate];
			for (int i = 1; i <= duration_fate; i++) 
			{
				span_row[i-1] = new BigDecimal(i);
			}
			_duration_fate[0] = new NUMBER(duration_fate);

			// нижеприведенный блок должен писать в _span_row[0]
			// аналогично _span_row[0]=((OracleConnection) DriverManager.getConnection("jdbc:default:connection")).createARRAY("FDNBI",span_row);
			// можно ли использовать тип java.sql.Array и непосредственно писать в него
			// http://www.javased.com/?api=java.sql.Array
			// текущий прием с передачей указателя на собственный объект мне кажется неудачным

			if(_this!=null)
			{
				_this.span_row = new double[duration_fate]; 
				for (int i = 1; i <= duration_fate; i++) 
				{
					_this.span_row[i-1] = span_row[i-1].doubleValue()+10.0*i;
				}   
			}	
			if(false) 
			{
				_span_row[0]=((OracleConnection) DriverManager.getConnection("jdbc:default:connection")).createARRAY("FDNBI",span_row);
			}
		} catch (Exception E) 
		{
			throw new IOException(E.getMessage()+" "+id_contract_sap);
		}
	}
    
	public Nbi_Exe(
                        boolean kind,
		        String _id_contract_sap, 
                        double _total_price
                      )
    	throws SQLException, IOException, ClassNotFoundException 
	{
		this.id_contract_sap    =_id_contract_sap;
		this.total_price        =_total_price;
		NUMBER[] _duration_fate = new NUMBER[1];
		Array[]  _span_row      = new Array[1];
		this.Oracle( 
                            (kind?this:null),
                            new String[]{_id_contract_sap},
                            new NUMBER[]{new NUMBER(total_price)},
                            _duration_fate,
                            _span_row
                           );
		this.duration_fate=_duration_fate[0].intValue();

		//Здесь бы хотел просканировать возвращенный _span_row и писать в поле созданного объекта
		//this.span_row = new double[this.duration_fate]; 
		//for (int i = 1; i <= this.duration_fate; i++) 
		//{
		//	this.span_row[i-1] = _span_row[i-1].doubleValue();
		//}   
	}
}
 
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 

package Analitic;

import java.sql.*;
import java.util.Map;

import oracle.sql.NUMBER;

import java.io.IOException;

public class Execute 
{
    public static void main(String[] args)
    throws SQLException, IOException, ClassNotFoundException 
    {
    	Nbi_Exe b = new Nbi_Exe(true,"s123",0.0);
    	System.out.println(b.id_contract_sap);
    	System.out.println(b.duration_fate);
    	if(b.span_row!=null) 
    	{
    		System.out.println(b.span_row[0]);
    		System.out.println(b.span_row[1]);
    		System.out.println(b.span_row[2]);
    		System.out.println(b.span_row[3]);
    		System.out.println(b.span_row[4]);
    	}
    }
}
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 

    ......................
    OracleConnection con = (OracleConnection) DriverManager.getConnection(URL, USERNAME, PASSWORD);

    Integer[] intValues = {1, 2, 3, 4, 5};
    Array array = con.createOracleArray("SYS.ODCINUMBERLIST", intValues);
    .......................
    con.close();
  }
}

                        if(_this!=null)
			{
				_this.span_row = new double[duration_fate]; 
				for (int i = 1; i <= duration_fate; i++) 
				{
					_this.span_row[i-1] = span_row[i-1].doubleValue()+10.0*i;
				}   
			}	
			if(_this==null) 
			{
				_span_row[0]=((OracleConnection) DriverManager.getConnection("jdbc:default:connection")).createARRAY("FDNBI",span_row);
			}