Skip to main content
D
dedip256565
September 6, 2022
Question

executeStoredProcedureForQuery error

  • September 6, 2022
  • 10 replies
  • 0 views

I am getting error as below on calling Oracle's stored procedure using a!executeStoredProcedureForQuery. 

Stored procedure and expression are attached below. Help is much appreciated.

    10 replies

    D
    deepakg681722
    September 7, 2022

    Did you try to run the procedure from DB side? I think the issue is from DB side only not from Appian Side.

    java.sql.SQLException: Invalid column type: 2012 when using Hibernate and Oracle stored procedure with REF_CURSOR - Hibernate ORM - Hibernate

    D
    dedip256565Author
    September 7, 2022

    Thank you Deepak for responding.

    Procedure is working fine and been used for a while.

    I am migrating from executestoredprocedure plugin to Appian executeStoredProcedureForQuery and getting this error.

    mikes0011
    mikes0011
    Brainy
    September 7, 2022

    What data type is ri!gcids?  I've noticed the OOB stored procedure rule is a bit more finnicky about little data differences than the older plug-in version, so I'd start there (particularly upon seeing the error message text).

    D
    dedip256565Author
    September 8, 2022

    Issue resolved by updating ojdbc8.jar

    JDBC and UCP Downloads page (oracle.com)

    P
    ponmalars0001
    March 28, 2023

    Hi [mention:ddd11f7e378549c9b6e953117046c036:e9ed411860ed4f2ba0265705b8793d05],

    We are also facing same issue with executeStoredProcedureForQuery SP function, will this solution resolved that "Invalid column type:2012" error, I need CLOB output as well along with CURSOR, 

    Terms & ConditionsAccessibility statement