select * from table (test.test())

NUMBER val = resultSet.getNUMBER(1); //,04[/quot]

create table fuckenVarcharTable(
  v varchar2(2000)
);

insert into fuckenVarcharTable select * from table (test.test());

commit;


create table fuckenNumberTable(
  v number(9,2)
);

insert into fuckenNumberTable select * from table (test.test());

commit;

    /**
     * Retrieves the value of the designated column in the current row
     * of this <code>ResultSet</code> object as
     * a <code>String</code> in the Java programming language.
     *
     * @param columnIndex the first column is 1, the second is 2, ...
     * @return the column value; if the value is SQL <code>NULL</code>, the
     * value returned is <code>null</code>
     * @exception SQLException if the columnIndex is not valid;
     * if a database access error occurs or this method is
     *            called on a closed result set
     */
    String getString(int columnIndex) throws SQLException;