Where’s my invalid character (ORA-00911)

by

If you use the string literal exactly as you have shown us, the problem is the ; character at the end. You may not include that in the query string in the JDBC calls.

As you are inserting only a single row, a regular INSERT should be just fine even when inserting multiple rows. Using a batched statement is probable more efficient anywy. No need for INSERT ALL. Additionally you don’t need the temporary clob and all that. You can simplify your method to something like this (assuming I got the parameters right):

String query1 = "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"";

String query2 = ".....";

String sql = "insert into domo_queries (clob_column) values (?)";
PreparedStatement pstmt = con.prepareStatement(sql);
StringReader reader = new StringReader(query1);
pstmt.setCharacterStream(1, reader, query1.length());
pstmt.addBatch();

reader = new StringReader(query2);
pstmt.setCharacterStream(1, reader, query2.length());
pstmt.addBatch();

pstmt.executeBatch();   
con.commit();

More Related Contents:

  1. Using setDate in PreparedStatement
  2. Oracle’s RETURNING INTO usage in Java (JDBC, Prepared Statement)
  3. PreparedStatement and setTimestamp in oracle jdbc
  4. having an exception when saving oracle type object in some entity
  5. PreparedStatement IN clause alternatives?
  6. How to connect to Oracle using Service Name instead of SID
  7. Java: Insert multiple rows into MySQL with PreparedStatement
  8. Using “like” wildcard in prepared statement
  9. Get query from java.sql.PreparedStatement [duplicate]
  10. How does a PreparedStatement avoid or prevent SQL injection?
  11. Variable column names using prepared statements
  12. Reusing a PreparedStatement multiple times
  13. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  14. right syntax to use near ‘?’
  15. How does Java’s PreparedStatement work?
  16. How to enable logging for SQL statements when using JDBC
  17. Difference between Oracle jdbc driver classes?
  18. PLSQL JDBC: How to get last row ID?
  19. Oracle JDBC intermittent Connection Issue
  20. Does the preparedStatement avoid SQL injection? [duplicate]
  21. How to write / update Oracle blob in a reliable way?
  22. Setting Network Timeout for JDBC connection
  23. mysql prepared statement error: MySQLSyntaxErrorException
  24. Call an Oracle function from Java
  25. Cannot use a LIKE query in a JDBC PreparedStatement?
  26. Connection timeout for DriverManager getConnection
  27. How to use prepared statement for select query in Java?
  28. Oracle JDBC : invalid username/password (ora-01017)
  29. JDBC Prepared Statement . setDate(….) doesn’t save the time, just the date.. How can I save the time as well?
  30. Iterating a ResultSet using the JDBC for Oracle takes a lot of time about 16s?

Leave a Comment