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