Re: Callable Statements

Mark:

To answer your question, you can't use CallableStatement where you return a row, rows or RECORD type.

For a function returning multiple rows, a single row, or RECORD you would have to use a PreparedStatement. The string passed to your prepared statement would resemble "select * from function"

I don't have an example on hand...but I may be able to get one for you later.

Scot

-------Original Message-------
From: Mark French <frenchmb(at)tpg(dot)com(dot)au>
Sent: 04/09/03 04:05 PM
To: pgsql-jdbc(at)postgresql(dot)org
Subject: [JDBC] Callable Statements

>
> Hi,

I'm new to postgres JDBC and was wondering if it supported callable
statements at all? The documentation doesn't have any examples and
would like to know it was possible to use them to call functions that
return multiple rows? An example would be greatly appreciated.

Cheers

Mark

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>