Re: Unsupported SQL Type 1111 when passing String to VARCHAR field

2009-12-23 Thread Christopher . Mathrusse
: christopher.mathru...@sybase.com Date: 12/23/2009 01:05 PM Subject: Re: Unsupported SQL Type when passing String to VARCHAR field Thanks let me try that. but what if I have multiple parameters going to this SP how will the syntax be then? {call procName (#searchUserId,jdbcType=VARCHAR

Re: Unsupported SQL Type 1111 when passing String to VARCHAR field

2009-12-23 Thread Christopher . Mathrusse
I personally opt for the in-line parameters. {call procName ( #searchUserId,jdbcType=VARCHAR,javaType=java.lang.String,mode=IN# ) } I use this syntax extensively with ASE and don't have any issues. Chris Mathrusse christopher.mathru...@sybase.com Sybase, Inc From: omnipresent To: