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?
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.