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
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
    Posts: 3353
    4/19/2011 12:44 PM
      What database are you running?
      Thanks for using the LawsonGuru.com forums!
      John
      M Graham
      Veteran Member
      Posts: 32
      Veteran Member
      4/19/2011 1:56 PM
        Our Lawson system runs on an Oracle database.
        Jayson
        New Member
        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
          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?