Oracle’s RETURNING INTO usage in Java (JDBC, Prepared Statement)

by

Because parameters specified in returning clauses are handled in a different way compared to normal output parameters(getReturnResultSet vs getResultSet vs returning parameters in a callablestatement).
They need to be handled with OraclePreparedStatement. In the second case when you wrap the insert statement in begin..end the insert is handled by the database itself and al jdbc sees is an anonymous plsql block.
http://docs.oracle.com/cd/E11882_01/java.112/e16548/oraint.htm#BABJJDDA

More Related Contents:

  1. Using setDate in PreparedStatement
  2. Where’s my invalid character (ORA-00911)
  3. PLSQL JDBC: How to get last row ID?
  4. Getting output from dbms_output.get_lines using JDBC
  5. PreparedStatement and setTimestamp in oracle jdbc
  6. having an exception when saving oracle type object in some entity
  7. PreparedStatement IN clause alternatives?
  8. Is java.sql.Timestamp timezone specific?
  9. How to connect to Oracle using Service Name instead of SID
  10. How can I get the SQL of a PreparedStatement?
  11. Using “like” wildcard in prepared statement
  12. Variable column names using prepared statements
  13. Reusing a PreparedStatement multiple times
  14. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  15. right syntax to use near ‘?’
  16. How to pass List from java to Oracle Procedure?
  17. How does Java’s PreparedStatement work?
  18. Oracle JDBC intermittent Connection Issue
  19. Does the preparedStatement avoid SQL injection? [duplicate]
  20. How to write / update Oracle blob in a reliable way?
  21. Execute anonymous pl/sql block and get resultset in java
  22. Setting Network Timeout for JDBC connection
  23. Java JDBC – How to connect to Oracle using tnsnames.ora
  24. Cannot use a LIKE query in a JDBC PreparedStatement?
  25. Connection timeout for DriverManager getConnection
  26. How to use prepared statement for select query in Java?
  27. Oracle JDBC : invalid username/password (ora-01017)
  28. How to read and extract zip entries from java.sql.Blob type zip file without having FileInputStream or filepath as a string java
  29. The Network Adapter could not establish the connection when connecting with Oracle DB
  30. Iterating a ResultSet using the JDBC for Oracle takes a lot of time about 16s?

Leave a Comment