Re: CallableStatements - Mailing list pgsql-jdbc

From Barry Lind
Subject Re: CallableStatements
Date
Msg-id 3C02807D.3020205@xythos.com
Whole thread Raw
In response to Re: CallableStatements  ("Dave Cramer" <Dave@micro-automation.net>)
List 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@iqa.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@postgresql.org
>
>



pgsql-jdbc by date:

Previous
From: Barry Lind
Date:
Subject: [Fwd: Re: Problems with truncated BLOB]
Next
From: Barry Lind
Date:
Subject: Re: ERROR WHEN I LOAD A LARGE OBJECT