Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread How to call a stored procedure from another stored procedure.
Tue, Aug 7 2012 1:28 PMPermanent Link

Abdulaziz Al-Jasser

I hope I am not asking too many questionsSmile
Regards,
Abdulaziz Jasser
Tue, Aug 7 2012 1:37 PMPermanent Link

Uli Becker

Abdulaziz,

> I hope I am not asking too many questionsSmile

Don't worry. Smile

Use CALL MyProcedure;

Uli
Tue, Aug 7 2012 2:11 PMPermanent Link

Abdulaziz Al-Jasser

Uli,

Thanks... but actually I am calling a function.  Therefore, I am expecting some return value.  How to retrieve it?
Regards,
Abdulaziz Jasser
Tue, Aug 7 2012 4:34 PMPermanent Link

Uli Becker

Abdulaziz,
> Thanks... but actually I am calling a function.  Therefore, I am expecting some return value.  How to retrieve it?

Supposed you have defined a function called GetLastDate() you can assign
the value to a variable within your procedure:

BEGIN

DECLARE FLastDate DATE;

SET FLastDate = GetLastDate(Param);

....

Uli
Wed, Aug 8 2012 1:24 PMPermanent Link

Abdulaziz Al-Jasser

Uli,

Big thanks....

Regards,
Abdulaziz Jasser
Image