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
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:
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