Stored Procedure declare parameter.

[sandipdk]

Hi all,

I am a newbie to Spring framework and was facing problem with stored procedures....

How to declare "in parameter" as well as "in/out parameter" in Spring?

I am declaring the outParameter as follows
declareParameter(new SqlOutParameter("ContactName", Types.VARCHAR));

Can anyone provide me a tutorial for the same?

[trisberg]

IN/OUT parameters are declared using SqlOutParameter and then providing an entry matching the name in the input parameter Map. IN parameters are declared as SqlParameter and OUT parameters are of course sSqlOutParameters. The order is important and they should be declared "left to right".

[sandipdk]

Thanks for the help.
Can u provide me any url for Spring Tutorial?