Re: Getting param names

From: Kris Jurka <books(at)ejurka(dot)com>
To: Srivats <scshekaran(at)riskspan(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Getting param names
Date: 2005-11-10 16:20:36
Message-ID: Pine.BSO.4.61.0511101117020.28629@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Thu, 10 Nov 2005, Srivats wrote:

> Is there anyway of getting all the IN Parameters of a particular Stored
> Procedure in JAVA.
>

As was suggested earlier, see DatabaseMetaData.getProcedureColumns:

http://java.sun.com/j2se/1.5.0/docs/api/java/sql/DatabaseMetaData.html#getProcedureColumns(java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String)

Although the postgresql driver hasn't been updated to handle the new out
parameters in 8.1.

Kris Jurka

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Guillaume Cottenceau 2005-11-10 16:52:11 Re: More Verbose Logging of Statements
Previous Message Rob Kirkbride 2005-11-10 16:19:53 Re: More Verbose Logging of Statements