The getProcedures api is on the todo list, but I don't think it returns
stored procs.
Dave
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Tony Grant
Sent: July 11, 2001 11:16 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
