Postgres Pro
Downloads
Home   >   mailing lists

Thread: Call pl/sql function

Call pl/sql function

From
Sangyoon Oh
Date:
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

Re: Call pl/sql function

From
"Scot P. Floess"
Date:
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@postgresql.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