1. Home
  2. General
  3. General Chat

Mapping of a store procedure that make an action and retrieve

Posts   
 
    
dorit
User
Posts: 16
Joined: 03-Jul-2006
# Posted on: 07-Sep-2006 17:34:36   

Hi,

I saw that there are two types of mapped SP: Action and Retrieval. My problem is that I have store procedures that make both in the same SP. how can I handle it ? Thanks in advance

JimHugh
User
Posts: 191
Joined: 16-Nov-2005
# Posted on: 07-Sep-2006 17:58:19   

The only effective difference between the two is that an Action proc returns 0 resultsets and a Retrieval returns 1 or more.

You can change the number of resultsets in the designer.

If you change it to 0, it becomes an Action proc.

Walaa avatar
Walaa
Support Team
Posts: 14987
Joined: 21-Aug-2005
# Posted on: 08-Sep-2006 07:13:45   

A SP which returns resultset, is a retrieval SP (whatever else it might be doing). A SP which does not return resultset, is an action SP.

So if you want to retrieve results from your SP, you should think of it as a Retrieval SP.