Symptoms
Is it possible to execute a SQL stored procedure from a workflow? If so, how can you execute the stored procedure?
Diagnoses
There are numerous ways to action a stored procedure from a workflow. You could create a smartobject for the stored procedure, write custom code to execute the stored procedure, or many other creative solutions.
Resolution
You can execute SQL using a smartobject. Furthermore, in your workflow you can use a smartobject event to action it within your process. Here is a link regarding smartobject events.
http://help.k2.com/onlinehelp/k2blackpearl/userguide/4.6.8/webframe.html_Event - SmartObject Event Wizard.html