At 09:52 PM 10/09/2003 +0800, you wrote:

>Hello,helen:
>
> >you wrote:
>
> >If you *want* to get multiple rows back, use a FOR SELECT...INTO
> ><variables> DO....SUSPEND and submit your request using a SELECT ... FROM
> >procedurename (parameter_list) statement instead of EXECUTE PROCEDURE
> >procedurename (parameter_list).
>
>
>You mean that 'EXECUTE PROCEDURE procedurename (parameter_list).' is not a
>good way?

EXECUTE PROCEDURE is fine for a singleton return set (the kind you get with
a SP that performs SELECT....INTO <variables>.

>If the procedure hasn't return value,how use the syntax 'SELECT ... FROM
>procedurename (parameter_list)'?

You don't use SELECT... FROM to execute procedures that don't have return
values. EXECUTE PROCEDURE is correct for them.

heLen