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

LPA Calling Oracle Stored Procedure Issue

 3 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Glenn Melvin
New Member Send Private Message
Posts: 2
New Member
7/9/2013 7:31 PM
Hello,
I'm getting the following error::
'ORA-00900: invalid SQL statement' trying to call an Oracle Stored Procedure:
Exec tcsx01.trunc_tcsx01_table('ORA_TABLE_NAME')
via SQLTxn Node.

LPA 10.0.2.8..5466 2012-10-11 21:41:29
Connecting to the Oracle db via JDBC.
Thanks.

Tags: LPA
Bob Canham
Veteran Member Send Private Message
Posts: 217
Veteran Member
7/10/2013 12:03 PM
I haven't done this in LPA yet, but I have used a different tool that uses a JDBC connection to Oracle. We used a Call statement rather than exec.

CALL tcsx01.trunc_tcsx01_table('ORA_TABLE_NAME')

Hope that works for you.
Tags: LPA
Erin
Advanced Member Send Private Message
Posts: 24
Advanced Member
7/16/2013 12:17 PM
Bob, Sadly it didn't help. We were trying to avoid doing free-style SQL but can't seem to crack the nut of how to call an oracle stored procedure via LPA
Tags: LPA
M Graham
Veteran Member Send Private Message
Posts: 32
Veteran Member
7/22/2013 8:08 PM
I had the same issue a while back when trying to call an Oracle SQL stored procedure in processflow. I worked with Infor/Lawson, and the rep said that Processflow only calls stored procedures using SQL Server, not Oracle SQL. However, I have not tried calling a SQL Server stored procedure in LPA, so I don't know for sure.
Tags: LPA