JDBC types for getting a ResultSet from a CallableStatement

From: Loren Cahlander <loren(at)ensodex(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: JDBC types for getting a ResultSet from a CallableStatement
Date: 2002-01-07 17:37:12
Message-ID: 3C39DCC8.5080402@ensodex.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2002-01-07 17:51:57 Re: How to cast a char[] to varchar?
Previous Message Jon Lapham 2002-01-07 14:30:20 How to cast a char[] to varchar?