qorelanguage / qore

Qore Programming Language
GNU General Public License v2.0
61 stars 10 forks source link

module-oracle: bulk binds of strings as CLOBs fails #4899

Closed davidnich closed 3 months ago

davidnich commented 3 months ago

once a string 32K bytes or longer is bound, the following error occurs: DBI:ORACLE:OCI-ERROR: omqarch@rippy: QorePreparedStatement::exec(): ORA-00932: inconsistent datatypes: expected - got CLOB (arg: {alterr: "OCI-00932"})

solution: scan the list, see if there is a string 32k bytes or longer, bind the array with CLOB values