Announcement Announcement Module
Collapse
No announcement yet.
Stored Procedure declare parameter. Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Stored Procedure declare parameter.

    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?

  • #2
    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".

    Comment


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

      Comment

      Working...
      X