Hi all,
I have the following table
CREATE TABLE "TABLE_TMP" (
"ISSUE_DATE" DATE,
"XML" XMLTYPE );
I am trying using java to fill the table.
using the following statement
String xmlStr ='...'; -- 186.400 characters
sqlStmt = "INSERT INTO TABLE_TMP VALUES(sysdate,'" + xmlStr + "')";
resultSet = statement.executeQuery(sqlStmt);
The error I get is that the literal is too long.
java.sql.SQLException: ORA-01704: string literal too long
Is there any way to do it ?
I want to keep the column as xmltype in order to be able to
manage it easily.
Thanks in advance