SSM error: ORA - 00942: the table or view does not exist at oracle.. JDBC driver. T4CTTIoer-CodePudding

[background] : SSM project, from the system to get the data in table vSqlarea to another self-built tables msa_vsqlarea, containing the fulltext CLOB fields, self-built also use CLOB storage the fields in the table,
1, we are synchronous data from vSqlarea to self-built tables msa_vsqlarea,
2, traverse the list in the code logic, insert insert in the mapper,

 
& lt; The insert id="insert" parameterType="MsaVslqlarea & gt;" 
Insert into msa_vsqlarea 
(
Sql_id, 
Sql_text. 
Sql_fulltext, 
First_load_time, 
Executions 
) 
Values 
(
# {sqlId jdbcType=VARCHAR}, 
# {sqlText jdbcType=VARCHAR}, 
# {sqlFulltext jdbcType=CLOB}, 
# {firstLoadTime jdbcType=VARCHAR}, 
# {executions, jdbcType=VARCHAR} 
) 
& lt;/insert>

[error message] :

 
ORA - 00942: a table or view does not exist at oracle.. JDBC driver. T4CTTIoer (T4CTTIoer. Java: 450)...

Before this, the background is spooled logs:

 
# # # SQL: insert into msa_vsqlarea (
Sql_id, 
Sql_text. 
Sql_fulltext, 
First_load_time, 
Executions 
) values (?,?,?,?,? ,? ,? ,? ,?) 
# # # Cause: Java. SQL. SQLException: ORA - 01461: can bind a Long value only for an inset into a Long colun

Preliminary positioning [] :
According to the background log to know that there are two possible,
First, the ojdbc driver problem, this temporarily not sure,
Second, the number of insert statements, more than 4000 fields into CLOB statement cannot directly insert, need to use the begin... End with,

Has two reform according to the scheme, a small amount of test data into feasible, large amount of data and temporary untested,

 
& lt; The insert id="insert" parameterType="MsaVslqlarea & gt;" 
Declare 
V_sql_fulltext CLOB:=# {sqlFulltext, jdbcType=CLOB}; 
The begin 
Insert into msa_vsqlarea 
(
Sql_id, 
Sql_text. 
Sql_fulltext, 
First_load_time, 
Executions 
) 
Values 
(
# {sqlId jdbcType=VARCHAR}, 
# {sqlText jdbcType=VARCHAR}, 
V_sql_fulltext, 
# {firstLoadTime jdbcType=VARCHAR}, 
# {executions, jdbcType=VARCHAR} 
); 
end; 
& lt;/insert>

Specific reasons temporarily did not know, ask bosses share experience guidance,