Re: Call pl/sql function

Sangyoon:

Does the function return setof table?

If so, you will have to use a PreparedStatement and do a select * from
function() to get the data. CallableStatement will not work as you will
get an error stating something to the effect that it is not supported
for type record.

I posted a similar question a week or two ago but it regarded using
CallableStatement's. I have some examples if you need some help...just
let me know.

Scot

Sangyoon Oh wrote:

>Hi,
>
> I am trying to call pl/sql function from jdbc, which is returns a
>table as a result set. Can anyone point out a help document?
> I have a Postgres book by by Ewald Geschwinde, but it doesn't
>cover much over pl/sql issue.
>
> Thanks,
>
>-Sangyoon Oh
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>message can get through to the mailing list cleanly
>
>
>

--
Scot P. Floess - 27 Lake Royale - Louisburg, NC 27549 - 252-478-8087

Open Source Home Page
--------------------------------------
http://javapim.sourceforge.net
http://jplate.sourceforge.net
http://jwaretechniques.sourceforge.net

Open Source Project Host
-----------------------------------------------
http://sourceforge.net/projects/javapim
http://sourceforge.net/projects/jplate
http://sourceforge.net/projects/jwaretechniques