• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Integration / Customization IPA/ProcessFlow

How to call a stored procedure in process flow?

 4 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
M Graham
Veteran Member Send Private Message
Posts: 32
Veteran Member
4/18/2011 9:37 PM
Has anyone been able to call a SQL stored procedure using process flow?  Is this possible?  I tried calling a SQL stored procedure using the SQL QUERY and SQL UPDATE nodes, but got an error "invalid SQL statement."  
I would prefer to call one stored procedure in process flow than use multiple SQL UPDATE nodes to update multiple tables. 
John Henley
Send Private Message
Posts: 3351
4/19/2011 12:44 PM
What database are you running?
Thanks for using the LawsonGuru.com forums!
John
M Graham
Veteran Member Send Private Message
Posts: 32
Veteran Member
4/19/2011 1:56 PM
Our Lawson system runs on an Oracle database.
Jayson
New Member Send Private Message
Posts: 2
New Member
6/15/2011 9:15 PM
I use a SQL Query activity node with the usual server information at the top. In the SQL Select field type "exec sp_name parameter1 parameter2 ..." Try that.
M Graham
Veteran Member Send Private Message
Posts: 32
Veteran Member
6/15/2011 10:09 PM
Thanks Jayson. I tried calling a stored procedure using both SQL QUERY and SQL UPDATE nodes using the format you suggested (exec sp_name parameter1 parameter2), but I get an error "invalid SQL statement ". Have you tried calling a stored procedure in an SQL QUERY or SQL UPDATE node, and does it work for you?