ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peng Wang <wpc...@gmail.com>
Subject Re: PL/pgSQL function not working in <select> (more info)
Date Sun, 08 May 2005 06:45:17 GMT
try this
<select id="getSilly" resultClass="int" parameterClass="string">
            select silly(#value#) from dual
 </select>

I think it can work.

On 5/8/05, Wolf <coyo@irresponsiblecybernetics.com> wrote:
> Hi Clinton,
> 
>   Thanks for the response.  I have tried this through raw JDBC :
>           con = DriverManager.getConnection("jdbc:postgresql:wiki");
>           stat = con.createStatement();
>           stat.executeQuery("select silly('foo')");
>   and that works as expected.
> 
>   I am using the same jdbc driver on both occasions.
> 
>   I did try select('foo') from dual but I got  ERROR: relation "dual"
> does not exist. I think DUAL is an oracle only psuedo-table.
> 
> -Wolf
> 
> On May 7, 2005, at 7:39 PM, Clinton Begin wrote:
> 
> >
> >  Try select silly(text) from dual.
> >
> >  Cheers,
> >  Clinton
> >
> 
>

Mime
View raw message