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

LPA Calling Oracle Stored Procedure Issue

3 Replies

0 Subscribed to this topic

53 Subscribed to this forum

Sort:

Author

Messages

Glenn Melvin

New Member

Posts: 0

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

Deleted User

New Member

Posts: 0

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.

Erin

Advanced Member

Posts: 24

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

M Graham

Veteran Member

Posts: 32

New Poster

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.