-
Jun 4th, 2007, 03:49 PM
#1
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
Marco
-
Jun 5th, 2007, 07:09 AM
#2
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules