Skip to main content
dedip256565
Participating Frequently
Sep 6, 2022 11:33 PM UTC
Question

executeStoredProcedureForQuery error

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

    deepakg681722
    Inspiring
    Sep 7, 2022 2:30 AM UTC

    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

    dedip256565Author
    Participating Frequently
    Sep 7, 2022 12:39 PM UTC

    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
    Sep 7, 2022 12:56 PM UTC

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

    The Expression Guru
    dedip256565Author
    Participating Frequently
    Sep 8, 2022 8:50 PM UTC

    Issue resolved by updating ojdbc8.jar

    JDBC and UCP Downloads page (oracle.com)

    ponmalars0001
    New Participant
    Mar 28, 2023 12:37 PM UTC

    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