(empire-db) branch master updated: EMPIREDB-456 DBMSHandlerOracle: convert to clob.

[doebele]

This is an automated email from the ASF dual-hosted git repository.

doebele pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/empire-db.git


The following commit(s) were added to refs/heads/master by this push:
     new 5ba6bbd2 EMPIREDB-456 DBMSHandlerOracle: convert to clob.
5ba6bbd2 is described below

commit 5ba6bbd26f20013d087534dfb6fb03301e71efed
Author: Rainer Döbele <doeb...@apache.org>
AuthorDate: Fri Apr 11 11:10:46 2025 +0200

    EMPIREDB-456
    DBMSHandlerOracle: convert to clob.
---
 .../main/java/org/apache/empire/dbms/oracle/DBMSHandlerOracle.java    | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

diff --git 
a/empire-db/src/main/java/org/apache/empire/dbms/oracle/DBMSHandlerOracle.java 
b/empire-db/src/main/java/org/apache/empire/dbms/oracle/DBMSHandlerOracle.java
index b2296340..5fdcf44a 100644
--- 
a/empire-db/src/main/java/org/apache/empire/dbms/oracle/DBMSHandlerOracle.java
+++ 
b/empire-db/src/main/java/org/apache/empire/dbms/oracle/DBMSHandlerOracle.java
@@ -257,12 +257,14 @@ public class DBMSHandlerOracle extends DBMSHandlerBase
             // Convert to text
             case VARCHAR:
             case CHAR:
-            case CLOB:
                 if (format instanceof String)
                 { // Convert using a format string
                     return "to_char(?, '"+format.toString()+"')";
                 }
                 return "to_char(?)";
+            // convert to clob
+            case CLOB:
+                return "to_clob(?)";
             // Convert to number
             case INTEGER:
             case FLOAT: