Re: Getting param names - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Getting param names
Date
Msg-id Pine.BSO.4.61.0511101117020.28629@leary.csoft.net
Whole thread Raw
In response to Getting param names  ("Srivats" <scshekaran@riskspan.com>)
Responses Re: Getting param names  (Dave Cramer <pg@fastcrypt.com>)
unsubscribe  (solar <solaurpers@yahoo.com>)
List 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


pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: getIndexInfo() not returning operator classes
Next
From: Guillaume Cottenceau
Date:
Subject: Re: More Verbose Logging of Statements