Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General Discussion » View Thread |
Messages 1 to 5 of 5 total |
How to call a stored procedure from another stored procedure. |
Tue, Aug 7 2012 1:28 PM | Permanent Link |
Abdulaziz Al-Jasser | I hope I am not asking too many questions
Regards, Abdulaziz Jasser |
Tue, Aug 7 2012 1:37 PM | Permanent Link |
Uli Becker | Abdulaziz,
> I hope I am not asking too many questions Don't worry. Use CALL MyProcedure; Uli |
Tue, Aug 7 2012 2:11 PM | Permanent 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 PM | Permanent 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 PM | Permanent Link |
Abdulaziz Al-Jasser | Uli,
Big thanks.... Regards, Abdulaziz Jasser |
This web page was last updated on Monday, May 6, 2024 at 03:23 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |