Re: Getting param names

Kris,

What new out parameters are you referring to ?

Dave
On 10-Nov-05, at 11:20 AM, Kris Jurka wrote:

>
>
> 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
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: explain analyze is your friend
>