Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

How to call a stored procedure in process flow?

4 Replies

0 Subscribed to this topic

53 Subscribed to this forum

Sort:

Author

Messages

M Graham

Veteran Member

Posts: 32

New Poster

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: 3366

New Poster

Engaged Reader

Avid Reader

4/19/2011 12:44 PM

What database are you running?

M Graham

Veteran Member

Posts: 32

New Poster

4/19/2011 1:56 PM

Our Lawson system runs on an Oracle database.

Jayson

New Member

Posts: 2

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

New Poster

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?