Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28])
	by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0R10Iq70045
	for <pgsql-interfaces@postgresql.org>;
	Fri, 26 Jan 2001 20:00:18 -0500 (EST)
	(envelope-from pgsql-interfaces-owner@postgresql.org)
Received: from news.tht.net (news.hub.org [216.126.91.242])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0Q3xfq50310
	for <pgsql-interfaces@postgresql.org>;
	Thu, 25 Jan 2001 22:59:41 -0500 (EST)
	(envelope-from news@news.tht.net)
Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id
 f0Q3uB910575
	for pgsql-interfaces@postgresql.org;
	Thu, 25 Jan 2001 22:56:11 -0500 (EST) (envelope-from news)
From: "Ron Sofrin" <rsofrin@entercept.com>
X-Newsgroups: comp.databases.postgresql.interfaces
Subject: Invoking sql functions through jdbc
Date: Thu, 25 Jan 2001 19:57:32 -0800
Organization: Entercept
Lines: 17
Message-ID: <94qsgr$aac$1@news.tht.net>
Reply-To: "Ron Sofrin" <rsofrin@entercept.com>
X-Complaints-To: scrappy@hub.org
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
To: pgsql-interfaces@postgresql.org
X-Archive-Number: 200101/305
X-Sequence-Number: 930

Hi all,

I am trying to invoke a postgres sql function though JDBC using the
CallableStatment object. I have build the driver with it's jdbc1.2 option.
However, I am getting the following exception "Callable statments are not
supported at this time"

Does any one have an idea if there is a work around it?

I have noticed that there is something called the Fastpath API. Is there any
way to get a result set (and not byte[]) out of it?

thanks

Ron