Re: Calling store procedure

[John Readman]

>> CAN I call a store procedure inside a store procedure, if so how?

You can, just do CALL ProcName ();

However if you want to pass a value back from the proc you can't use the = construct, that would require a function as stated by Roland, but you can make one of the stored procedure parameters an output parameter if that suits your purpose.

e.g.

create procedure MyProc (OUT MyParam INT)
/* does something that gives MyParam a value */

...then inside another proc you can

declare MyVar INT;
call MyProc (MyVar);

MyVar contains the value from the procedure call.



Edited 1 time(s). Last edit at 11/14/2005 11:11AM by John Readman.