Re: CallableStatements

From: Barry Lind <barry(at)xythos(dot)com>
To: gbittar(at)iqa(dot)cc
Cc: Dave(at)micro-automation(dot)net, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: CallableStatements
Date: 2001-11-26 17:48:45
Message-ID: 3C02807D.3020205@xythos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

And you can easily do that using a regular Statement or
PreparedStatement by issuing the 'select foo()' select (where foo is the
function you want to call). You don't need to have CallableStatements
to call stored procedures in postgres.

--Barry

gbittar(at)iqa(dot)cc wrote:

> If you are offloading a lot of processing onto your server, then really all
> you want to do is send it some parameters, wait while work gets done, and
> get a result code to find out how things went.
>
> Dave Cramer wrote:
>
>
>>Well, given that postgres doesn't support the notion of returning a
>>result set from a stored procedure; I'm not sure what benefit this would
>>be.
>>
>>Regards,
>>
>>Dave
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2001-11-26 17:52:17 [Fwd: Re: Problems with truncated BLOB]
Previous Message Stuart Robinson 2001-11-26 17:47:34 Re: CallableStatements