Announcement Announcement Module
Collapse
No announcement yet.
Supports Spring functions with SqlOutParameters? Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Supports Spring functions with SqlOutParameters?

    Hello people,

    I have a question: Supports Spring functions with SqlOutParameters?
    I need convert some functions to Spring.
    My Data Base is Oracle

    My old function is:

    ...
    CallableStatement cstmt = null;
    MyBean myBeanOut = null;
    try {
    cstmt = conn.prepareCall("{?=call MY_FUNCTION(?,?)}");
    cstmt.registerOutParameter(1, Types.VARCHAR);
    cstmt.setString(2, pId);
    cstmt.registerOutParameter(3, Types.VARCHAR);
    cstmt.execute();
    myBeanOut.setPOut1(cstmt.getString(1));
    myBeanOut.setPOut2(cstmt.getString(3));
    }
    ...

    Thanks for your help!

    Javier
Working...
X