哪里是我的無效角色(ORA-00911)我正在嘗試將CLOBs插入數據庫(請參閱相關問題)。我無法弄清楚出了什么問題。我有一個大約85個clobs的列表,我想插入表中。即使只插入我得到的第一個clob ORA-00911: invalid character。我無法弄清楚如何PreparedStatement在執行之前獲取聲明,因此我無法100%確定它是正確的,但如果我做對了,那么它看起來應該是這樣的:insert all into domo_queries values ('select
substr(to_char(max_data),1,4) as year,
substr(to_char(max_data),5,6) as month,
max_data
from dss_fin_user.acq_dashboard_src_load_success
where source = ''CHQ PeopleSoft FS''')select * from dual;最終,這個insert all陳述會有很多into,這就是我不做常規insert陳述的原因。我沒有在那里看到無效的角色,對嗎?(哦,當我在我的sql開發人員工具中運行它時,上面的代碼運行正常。)如果我刪除了分號PreparedStatement,它會拋出ORA-00933: SQL command not properly ended錯誤。在任何情況下,這是我執行查詢的代碼(以及上面示例的變量值)。public ResultSet executeQuery(String connection, String query, QueryParameter... params) throws DataException, SQLException {
// query at this point = "insert all
//into domo_queries values (?)
//select * from dual;"
Connection conn = ConnectionPool.getInstance().get(connection);
PreparedStatement pstmt = conn.prepareStatement(query);
for (int i = 1; i <= params.length; i++) {
QueryParameter param = params[i - 1];
switch (param.getType()) { //The type in the example is QueryParameter.CLOB
case QueryParameter.CLOB:
Clob clob = CLOB.createTemporary(conn, false, oracle.sql.CLOB.DURATION_SESSION);
clob.setString(i, "'" + param.getValue() + "'");
//the value of param.getValue() at this point is:
/*
* select
* substr(to_char(max_data),1,4) as year,
* substr(to_char(max_data),5,6) as month,
* max_data
* from dss_fin_user.acq_dashboard_src_load_success
* where source = ''CHQ PeopleSoft FS''
*/
pstmt.setClob(i, clob);
break;
case QueryParameter.STRING:
pstmt.setString(i, "'" + param.getValue() + "'");
break;
}
}有什么我只是錯過了很多時間嗎?
添加回答
舉報
0/150
提交
取消