cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using execute procedure in Execute SQL

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},{ItemPropertySmiley Very Happyate_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?

Labels: (2)
0 Kudos
Reply
2 Replies
fhunth
Nintex Newbie

Re: Using execute procedure in Execute SQL

I suggest you to run some test cases:

  1. Call the sp with fixed parameters that you know it 'd get a result
  2. Call the sp with fixed parameters that you know it'd get an error
  3. Call the sp with the Nintex variables
0 Kudos
Reply
mapeacock
Nintex Newbie

Re: Using execute procedure in Execute SQL

Hi,

Have you tried using the "Run Now" option on the control to test your call on the fly? This might give you more meaningful return data.

Regards,

Mark

0 Kudos
Reply