Since switching the challenge column in the Challenge table to db.Text (in v3.12) Oracle dbs throw an error when checking querying challenges: "ORA-00932: inconsistent datatypes: expected - got CLOB"
db.Text gets converted to CLOB in Oracle but it can not be used in a where clause: https://stackoverflow.com/a/12980560
Maybe we can use the clob_to_varchar function defined in lib/token.py:
|
class clob_to_varchar(FunctionElement): |
Since switching the
challengecolumn in theChallengetable todb.Text(in v3.12) Oracle dbs throw an error when checking querying challenges: "ORA-00932: inconsistent datatypes: expected - got CLOB"db.Textgets converted toCLOBin Oracle but it can not be used in a where clause: https://stackoverflow.com/a/12980560Maybe we can use the
clob_to_varcharfunction defined inlib/token.py:privacyidea/privacyidea/lib/token.py
Line 135 in c814595