Re: ORA-06572: Function has OUT parameters

2008-09-11 Thread Vadim
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=

Re: ORA-06572: Function has OUT parameters

2008-09-11 Thread Clinton Begin
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

Fwd: ORA-06572: Function has OUT parameters

2008-09-11 Thread Vadim
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