RE: JDBC and stored procedures - Mailing list pgsql-jdbc

From Dave Cramer
Subject RE: JDBC and stored procedures
Date
Msg-id 003401c10a24$a19d5e30$0201a8c0@inspiron
Whole thread Raw
In response to Re: JDBC and stored procedures  (Tony Grant <tony@animaproductions.com>)
List pgsql-jdbc
The getProcedures api is on the todo list, but I don't think it returns
stored procs.

Dave

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Tony Grant
Sent: July 11, 2001 11:16 AM
To: Dave@micro-automation.net
Cc: pgsql-jdbc@PostgreSQL.org; pgsql-general@PostgreSQL.org
Subject: Re: [JDBC] JDBC and stored procedures


On 11 Jul 2001 10:20:29 -0400, Dave Cramer wrote:

> The GetProcedures function in the driver does not work.

OK. I bet it is on the todo list =:-D

> You should be able to a simple select of the stored proc however

Yes! thank you very much!!!

SELECT getcountryname(director.country)

did the trick where getcountryname is the function (or stored procedure)

Cheers

Tony

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



pgsql-jdbc by date:

Previous
From: Tony Grant
Date:
Subject: Re: JDBC and stored procedures
Next
From: "Dejan Vucinic"
Date:
Subject: can't write a BLOB, 7.1.2