I didn't really get your solution. My problem is - you can't have a function
returning a value AND having an OUT parameter in a SQL statement.Question
is: if I convert function 'with_out'
SELECT id, class
FROM TABLE(with_out
(#in,mode=IN,jdbcType=VARCHAR#,#out,mode=OUT,jdbcType=
Try this, if it's too much to put in your SQL, you can use an external
parameter map.
#in,jdbcType=VARCHAR,mode=OUT#,
#out,jdbcType=VARCHAR,mode=OUT#
Clinton
On Thu, Sep 11, 2008 at 7:09 AM, Vadim <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I've been thinking how to do this for too long now. Ibatis
Hello,
I've been thinking how to do this for too long now. Ibatis version is
2.1.0.565, Oracle version is 9. What I'm trying to do is map a statement to
a Java class and get one varchar OUT parameter. PL/SQL function is like
function with_out (
in_param in varchar2,
out_messageout