Обсуждение: JDBC types for getting a ResultSet from a CallableStatement

Поиск
Список
Период
Сортировка

JDBC types for getting a ResultSet from a CallableStatement

От
Loren Cahlander
Дата:
Hello,

The following is a very stripped down block of code, but it
gets at the heart of my question.  The type used in this
block of code is specific to the Oracle database driver.
What types do I need for the Postgresql database driver?  I would
appreciate any help.

============================================================
CallableStatement stmt= null;
ResultSet resultSet = null;

stmt = conn.prepareCall("{call GetEmployees(?)}");

stmt.registerOutParameter(1,
                           oracle.jdbc.driver.OracleTypes.CURSOR);
stmt.execute();
resultSet = (ResultSet)stmt.getObject(1);
============================================================


Thanks,
Loren