Обсуждение: Call pl/sql function

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

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


When I wrote this text a long long time ago there was no way to work
with table functions yet and PL/pgSQL was not that good either. I hope
you still like the book :).

Here is some information about PL/pgSQL and table functions. You need
"RETURN NEXT".

http://developer.postgresql.org/docs/postgres/plpgsql-control-structures.html

    Regards,

        Hans


--
Cybertec Geschwinde u Schoenig
Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria
Tel: +43/2952/30706; +43/664/233 90 75<
www.sapdb.at, www.cybertec.at, www.postgresql.at, kernel.cybertec.at