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
>
>
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 |