Announcement Announcement Module
No announcement yet.
Stored PRocedures / how to access resultsets Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • Stored PRocedures / how to access resultsets

    hi all,
    i am trying to call stored procedures using Spring,
    I am following docs so i created a class that extends SToredProcedures

    my stored procedure returns a resultSet, so i thought that i fi call my SP, the Map returned by execute() method will give me the returned resultset, but in fact the map returned is empty.
    i don't have code with me now, but i was wondering why it was not working, as i have called successfully a SP via spring (this time though the SP didnt return anything so it was successful)
    my questions are:
    1) the Map returned by execute method of SP class will re present the different rows of a resultSet?
    2) in order to return a resultSet, do ihave to declare a SqlOutParameter?

    anyone could give me some suggestions?

    thanks in advance and regards

  • #2
    The reference manual has an example of this.