Skip to main content
Nintex Community Menu Bar

Dynamic SQL SP Service

  • May 27, 2009
  • 1 reply
  • 8 views

Forum|alt.badge.img+6

Is any additional config required to be done after registering the dynamic SQL SP service type and instance?


 


 I did so, created and compiled a stored proc but are unable to view it below the service instance in the object


browser when trying to use it within a Smart Object method.


 


Any suggestions?

1 reply

Forum|alt.badge.img+6
  • Author
  • May 27, 2009

Ok, figured this out....


 


Do not name your stored procedure with the SQL standard prefix "sp_", these are ignored within the Dynamic SQL SP Service.


 


Also, use the Smart Object method parameters to indicate your parameters of the stored proc, just adding them as a property


marked as Input will not work.