Robert,

Unlike "standard" SPs, dataset SP's (Sp's which return a dataset) must
be accessed using a SELECT, instead of EXECUTE PROCEDURE.

In fact, a dataset SP can be treated in the same manner you would a
Table/View, SELECT OutputParamA, OutputParamB FROM SOME_PROCEDURE(
InputParam1, InputParam2, ...) WHERE ... ORDER BY ...


Sean

> -----Original Message-----
> From: Robert F. Tulloch [mailto:tultalk@...]
> Sent: Monday, October 23, 2000 4:19 PM
> To: IBDI@egroups.com
> Subject: [IBDI] Stored Procedure-Dataset
>
>
> Hi:
>
> In stored proc returning dataset do you have to declare all the
> fields returned in Returning or does it just return the dataset?
>
> Thanks.
>
> Best regards
>
> Community email addresses:
> Post message: IBDI@onelist.com
> Subscribe: IBDI-subscribe@onelist.com
> Unsubscribe: IBDI-unsubscribe@onelist.com
> List owner: IBDI-owner@onelist.com
>
> Shortcut URL to this page:
> http://www.onelist.com/community/IBDI
>