SonalVaidya

Is there any way to store value returned by SP into a GEL variable??

Discussion created by SonalVaidya on Oct 12, 2010
Latest reply on Oct 12, 2010 by SonalVaidya
Hi All,      I need one help in GEL Script, I am trying to write a gel script which executes a stored procedure.                                   inside sql                                DECLARE @P_ID     nvarchar (80)                                SET @P_ID     = NULL                                EXEC   GET_PROJ_ID_SP 'project', @P_ID OUT                                SELECT @P_ID AS '@P_ID'                            outside sql         Here my procedure is working fine but the problem is how to get output into a GEL Variable which is returned by Stored Procedure?      Is there any way to store value returned by SP into a GEL variable??      Any feedback is greatly appreciated.    ~Sonal

Outcomes