create or replace and resolve java source named Address as 
import java.sql.*;
import java.oi.*;
import java.util.Date;
import oracle.sql.*;
public class Address implements SQLData {

  String sql_type = "address";
  public String street;
  public String city;
  public String total;
  
  public Address()
  {
  }

  public Address(String sql_type,String street,String city)
  {
    this.sql_type = sql_type;
    this.street   = street  ;
    this.city     = city    ;
  }
  
  public String getSQLTypeName() 
  throws SQLException 
  {
    return sql_type;
  }
  
  public void readSQL(SQLInput stream, String typeName) 
  throws SQLException 
  {
    sql_type = typeName;
    SQLInput istream = (SQLInput) stream;
    street = istream.readString();
    city   = istream.readString();
  }

  public void writeSQL(SQLOutput stream) 
  throws SQLException 
  {
    SQLOutput ostream = (SQLOutput) stream;
    ostream.writeString(street);
    ostream.writeString(city);
  }

  public void exeCalc()
  {
    this.total=this.city+' '+this.street;
  }

  public String getExecute(String execute)
  {
    exeCalc();
    return execute;
  }

  public String getTotal(String pref)
  {
    exeCalc();
    return pref+'_'+this.total;
  }
  
  public String getCity(String pref)
  {
    return pref+'_'+this.total;
  }

}

create or replace type Address as object
       external name 'Address' language java
       using sqldata (
                      street varchar2(100) external name 'street',
                      city   varchar2(100) external name 'city',
                      static function create_address(street varchar,city varchar) return Address
                      external name 'create (java.lang.String, java.lang.String) return Address',
                      static function construct (street varchar,city varchar) return Address
                      external name 'create (java.lang.String, java.lang.String) return Address',
                      member function GetExecute(s varchar) return varchar2
                      external name 'getExecute(java.lang.String) return java.lang.String',
                      member function GetCity(s varchar) return varchar2
                      external name 'getCity(java.lang.String) return java.lang.String',
                      member function GetTotal(s varchar) return varchar2
                      external name 'getTotal(java.lang.String) return java.lang.String'
                     );
drop table ADDRESSLIST;
create table ADDRESSLIST (id number,ad address);
insert into ADDRESSLIST values (10,ADDRESS('1vvv','1fhhff')) ;
insert into ADDRESSLIST values (20,ADDRESS('2vvv','2fhhff')) ;
insert into ADDRESSLIST values (30,ADDRESS('3vvv','3fhhff')) ;
insert into ADDRESSLIST values (40,ADDRESS('4vvv','4fhhff')) ;
commit;

select t.*,
       t.ad.GetExecute('execute') f0,
       t.ad.GetTotal(t.ad.city)   f1,
       t.ad.GetCity('ggg')        f2 
  from ADDRESSLIST t

 
ID	AD.STREET	AD.CITY	F0	F1	F2
10	1vvv	3fhhff	execute	3fhhff_3fhhff 1vvv	ggg_null
20	2vvv	3fhhff	execute	3fhhff_3fhhff 2vvv	ggg_null
30	3vvv	3fhhff	execute	3fhhff_3fhhff 3vvv	ggg_null
40	4vvv	3fhhff	execute	3fhhff_3fhhff 4vvv	ggg_null

public class Hello
{
  public static String you(String name)
  {
    return "Hello "+name;
  }
}


 CREATE OR REPLACE FUNCTION hello RETURN VARCHAR2 AS
   LANGUAGE JAVA NAME 'Hello.you (java.lang.String) return java.lang.String';
    

SELECT hello('world') , hello('HOME_X')  from dual;

select A.*,
         MyType(A.F1,A.F2).F3               -- здесь мой Java код, но код должен выполниться один 
         MyType(A.F1,A.F2).F4               -- раз (расчет замороченный), а возврат полей класса, 
         MyType(A.F1,A.F2).F5               -- по желанию пользователя - одно поле или 25 полей
         ..............................
         MyType(A.F1,A.F2).F25 
 from (select 'A' F1
                   10 F2
            from DUAL -- здесь сделал набивку параметров
         ) A

 
    this.sql_type = sql_type;
    this.street   = street  ;
    this.city     = city    ;

select F1,
         F2.City F3
         F2.Street F4 
    from (select 'AA' F1,
                       (select Address().Calculate('London','BS-125 B')
                          from DUAL
                       ) F2
               from DUAL
            )

create or replace type Address as object
       external name 'Address' language java
       using sqldata (
                      blank varchar2(100) external name 'blank',  -- не должен участвовать в конструкторе
--                    static function  AAA varchar2(100) external variable name 'city', ??????!!!!!! не подключается  на Public static String S="gg"
                      constructor function Address(blank varchar2,city varchar2) return self as result
                             external name 'Address(java.lang.String,java.lang.String,java.lang.String) return Address',
--                      static function create_address return Address
--                             external name 'create() return Address',
--                      static function construct return Address
--                             external name 'create() return Address',
--                      static function create_address (blank varchar2) return Address
--                             external name 'create(java.lang.String) return Address',
--                      static function construct (blank varchar2) return Address
--                             external name 'create(java.lang.String) return Address',
                      member function Calculate (city varchar2,street varchar2) return Address
                             external name 'Calculate(java.lang.String,java.lang.String) return Address'
                     )

create or replace and compile java source named address as
import java.sql.*;
import java.oi.*;
import java.util.Date;
import oracle.sql.*;

public class Address implements SQLData {

  String sql_type = "address";
  public String city;
  public String street;
  public String total;

  public Address()
  {

  }

  public Address(String sql_type)
  {
    this.sql_type = sql_type;
  }
  
  public Address Calculate(String city,String street)
  {
    this.city   = "Java class "+city;
    this.street = "Java class "+street;
    this.total  = "Java class "+city+"_"+street;
    return this;
  }

  public String getSQLTypeName() 
  throws SQLException 
  {
    return sql_type;
  }
  
  public void readSQL(SQLInput stream, String typeName) 
  throws SQLException 
  {
    sql_type = typeName;
    SQLInput istream = (SQLInput) stream;
    city   = istream.readString();
    street = istream.readString();
    total  = istream.readString();
  }

  public void writeSQL(SQLOutput stream) 
  throws SQLException 
  {
    SQLOutput ostream = (SQLOutput) stream;
    ostream.writeString(city);
    ostream.writeString(street);
    ostream.writeString(total);
  }
}

create or replace type Address as object
       external name 'Address' language java
       using sqldata (
                      city   varchar2(100)  external name 'city',
                      street varchar2(100) external name 'street',
                      total  varchar2(100)  external name 'total',
                      constructor function Address return self as result,
                      member function Calculate (city varchar2,street varchar2) return Address
                             external name 'Calculate(java.lang.String,java.lang.String) return Address'
                     );
/
create or replace type body Address as
  constructor function Address return self as result
  as begin
    return;
  end;
end;
/

select A.F1,
       A.F2,
       A.CALC.CITY,
       A.CALC.STREET,
       A.CALC.TOTAL 
  from (select A.*,
               (select Address().Calculate(A.F1,A.F2) 
                  from DUAL
               ) CALC   
          from (select 'London'   F1,
                       'BS-125 B' F2
                  from DUAL
               ) A
       ) A