Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE AND COMPILE JAVA SOURCE NAMED test_sqlstate_java AS
import java.sql.*;

public class TestSQLState
{
  public static String test (int numerator, int denominator) throws SQLException
  {
    String sql = "SELECT ?/? FROM DUAL";
    try
    {
      Connection conn = DriverManager.getConnection("jdbc:default:connection:");
      PreparedStatement pstmt = conn.prepareStatement(sql);
      pstmt.setInt(1, numerator);
      pstmt.setInt(2, denominator);
      ResultSet rset = pstmt.executeQuery();
      pstmt.close();
      
    }
    catch (SQLException e) 
    {
      return e.getSQLState();
    }
    return null;
  }
}
CREATE FUNCTION test_sqlstate( numerator IN NUMBER, denominator IN NUMBER ) RETURN VARCHAR2
AS LANGUAGE JAVA NAME 'TestSQLState.test( int, int ) return java.lang.String';
/
SELECT test_sqlstate( 1, 0 ) AS sqlstate FROM DUAL;


SQLSTATE


22012