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 <[EMAIL PROTECTED]> 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
> >
>
>
