how to catch returned refcursor from a fuction

From: "Fernando Papa" <fpapa(at)claxson(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: how to catch returned refcursor from a fuction
Date: 2002-10-21 19:43:12
Message-ID: CB94A4924490EC4A81EDA55BA378B7BA3B669B@exch2k01.buehuergo.corp.claxson.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


Hi everybody!
I was read several posts about the posibility or not to handle refcursor
returned by a function on jdbc... and I don't understand.
It is posible? I know actually stable drivers doesn't support
CallableStatement.
On another post, I read "You will need to use a regular
Statement/Prepared Statement object and execute a 'select * from func()'
sql statement"...

Somebody have an example of this? I try to do this but I can't get
anything... It's very har to find examples of this kind of things in
postgres...

Thanks in advance

--
Fernando O. Papa

Browse pgsql-jdbc by date

  From Date Subject
Next Message Jean-Luc Lachance 2002-10-21 20:54:08 Re: URGENT: Help with exception
Previous Message john guthrie 2002-10-21 19:35:07 Re: Trouble connecting