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

2009-12-23 Thread Christopher . Mathrusse
Its pretty much the same thing, just add your additional parameter statements comma separated. You can even specify output parameters as well, to return values from the proc other than a rowset. You can also, if you would like, specify the parameter name. ASE has no issue with this and sometime

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:

Unsupported SQL Type 1111 when passing String to VARCHAR field

2009-12-23 Thread omnipresent
I have been smashing my head against this for a while now. I am using iBatis with my JAVA code to run Stored Proc residing in Sybase DB. Stored procedure is expecting some parameters. few of them are declared as VARCHAR (6) So in my iBatis mapping i did the following for those parameters. Ho