AnsweredAssumed Answered

Using execute procedure in Execute SQL

Question asked by nafiseh on Mar 26, 2015
Latest reply on Mar 26, 2015 by mapeacock

Hi ,

 

I have to call the following procedure in the Query section of Execute SQL action

 

declare

  v_result number;

begin

psb_opseu_lieu_import(fn-Substring({ItemProperty:Employee_x0020_Number},5,8),{WorkflowVariable:varCode},{ItemProperty:Date_x0020_to_x0020_be_x0020_Wor},{ItemProperty:Approved_x0020_Actual_x0020_Hour},'P0064400',{WorkflowVariable:varResult});

end;

 

 

the result of ,{WorkflowVariable:varResult} would identify if the procedure executed successfully or not.

 

Seems like it is not working but I do not get any error.

 

Can you find out what is the issue?

Outcomes