Announcement Announcement Module
Collapse
No announcement yet.
Spring + iBATIS + Stored procedure output parameter Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Spring + iBATIS + Stored procedure output parameter

    I am using iBATIS to retrieve the data from database. I am calling a stored procedure which takes 3 input parameters, out of which one serves as input and ouput. I have set the mode this parameter as INOUT in my xml file. When i call the stored procedure throug my java code, it gives me error - "retrieval of output parameters failed".
    Stored procedure Output Parameter does work with spring + iBATIS ?
    Please help...!!!!!!

  • #2
    Have a look at these, they may help, otherwise you need to post your sqlmap xml and Java code.

    http://opensource.atlassian.com/conf...d+procedure%3F

    http://www.mail-archive.com/user-jav.../msg01021.html

    Comment


    • #3
      A sample code reference for the above issue

      Check out the link

      http://www.moorthyhome.com/blog/entr...ored_procedure

      Comment


      • #4
        I have problems with this stored procedure:
        PROCEDURE cifrarDato(
        cadena IN varchar2,
        cadenacifrada OUT varchar2,
        proceso IN char,
        ncoderr OUT number,
        msgerr OUT varchar2);


        I don't know how i can get return values in IBATIS.

        I hope someone can help me.

        atte JFAA

        Comment

        Working...
        X