List of registerOutParameter() Examples

Examples of registerOutParameter()

com.alibaba.druid.proxy.jdbc.CallableStatementProxyImpl.registerOutParameter()
java.sql.CallableStatement.registerOutParameter()
Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType. All OUT parameters must be registered before a stored procedure is executed.
The JDBC type specified by sqlType for an OUT parameter determines the Java type that must be used in the get method to read the value of that parameter.
If the JDBC type expected to be returned to this output parameter is specific to this particular database, sqlType should be java.sql.Types.OTHER. The method {@link #getObject} retrieves the value. @param parameterIndex the first parameter is 1, the second is 2,and so on @param sqlType the JDBC type code defined by java.sql.Types.If the parameter is of JDBC type NUMERIC or DECIMAL, the version of registerOutParameter that accepts a scale value should be used. @exception SQLException if the parameterIndex is not valid;if a database access error occurs or this method is called on a closed CallableStatement @exception SQLFeatureNotSupportedException if sqlType isa ARRAY, BLOB, CLOB, DATALINK, JAVA_OBJECT, NCHAR, NCLOB, NVARCHAR, LONGNVARCHAR, REF, ROWID, SQLXML or STRUCT data type and the JDBC driver does not support this data type @see Types
oracle.jdbc.OracleCallableStatement.registerOutParameter()
oracle.jdbc.driver.OracleCallableStatement.registerOutParameter()

Examples of java.sql.CallableStatement.registerOutParameter()


      clear();


      oStmt.setObject(1, aPK[0], Types.CHAR);       // gu_microsite
      oStmt.registerOutParameter(2, Types.INTEGER); // id_app
      oStmt.registerOutParameter(3, Types.VARCHAR); // nm_microsite
      oStmt.registerOutParameter(4, Types.VARCHAR); // path_metadata
      oStmt.registerOutParameter(5, Types.CHAR);    // gu_workarea


      if (DebugFile.trace) DebugFile.writeln("CallableStatement.execute()");

View Full Code Here

Examples of java.sql.CallableStatement.registerOutParameter()

      clear();


      oStmt.setObject(1, aPK[0], Types.CHAR);       // gu_microsite
      oStmt.registerOutParameter(2, Types.INTEGER); // id_app
      oStmt.registerOutParameter(3, Types.VARCHAR); // nm_microsite
      oStmt.registerOutParameter(4, Types.VARCHAR); // path_metadata
      oStmt.registerOutParameter(5, Types.CHAR);    // gu_workarea


      if (DebugFile.trace) DebugFile.writeln("CallableStatement.execute()");


      oStmt.execute();

View Full Code Here

Examples of java.sql.CallableStatement.registerOutParameter()


      oStmt.setObject(1, aPK[0], Types.CHAR);       // gu_microsite
      oStmt.registerOutParameter(2, Types.INTEGER); // id_app
      oStmt.registerOutParameter(3, Types.VARCHAR); // nm_microsite
      oStmt.registerOutParameter(4, Types.VARCHAR); // path_metadata
      oStmt.registerOutParameter(5, Types.CHAR);    // gu_workarea


      if (DebugFile.trace) DebugFile.writeln("CallableStatement.execute()");


      oStmt.execute();

View Full Code Here

Examples of java.sql.CallableStatement.registerOutParameter()

            CallableStatement st = conn.prepareCall(sql);
            st.setString(2, "COL2XML");
            st.setString(3, "colValue");
            st.setString(4, "colName");
            st.setLong(5, 1L);
            st.registerOutParameter(1, Types.CLOB);
            ResultSet rs = st.executeQuery();
            Clob clob = st.getClob(1);
            long len = clob.length();
            byte[] buf = new byte[(int)len];
            clob.getAsciiStream().read(buf);

View Full Code Here

Examples of java.sql.CallableStatement.registerOutParameter()

            CallableStatement st = conn.prepareCall(sql);
            st.setString(2, "COL2XML");
            st.setString(3, "prova");
            st.setString(4, "test");
            st.setLong(5, 1L);
            st.registerOutParameter(1, Types.CLOB);
            ResultSet rs = st.executeQuery();
            Clob clob = st.getClob(1);
            long len = clob.length();
            byte[] buf = new byte[(int)len];
            clob.getAsciiStream().read(buf);

View Full Code Here

Examples of java.sql.CallableStatement.registerOutParameter()

            CallableStatement st = conn.prepareCall(sql);
            st.setString(2, "COL2XML");
            st.setString(3, "<![CDATA[colValue]]>");
            st.setString(4, "colName");
            st.setLong(5, 1L);
            st.registerOutParameter(1, Types.CLOB);
            ResultSet rs = st.executeQuery();
            Clob clob = st.getClob(1);
            long len = clob.length();
            byte[] buf = new byte[(int)len];
            clob.getAsciiStream().read(buf);

View Full Code Here

Examples of java.sql.CallableStatement.registerOutParameter()

            CallableStatement st = conn.prepareCall(sql);
            st.setString(2, "COL2XML");
            st.setString(3, "c&lt;olValue");
            st.setString(4, "colName");
            st.setLong(5, 1L);
            st.registerOutParameter(1, Types.CLOB);
            ResultSet rs = st.executeQuery();
            Clob clob = st.getClob(1);
            long len = clob.length();
            byte[] buf = new byte[(int)len];
            clob.getAsciiStream().read(buf);

View Full Code Here

Examples of java.sql.CallableStatement.registerOutParameter()

            for (int i=0; i < 2; i++) {
               // sql = "{? = call nextval('repl_seq')}";
               sql = "{? = call " + this.replPrefix + "increment()}";
               CallableStatement st = conn.prepareCall(sql);
               // st.registerOutParameter(1, Types.BIGINT);
               st.registerOutParameter(1, Types.INTEGER);
               ResultSet rs = st.executeQuery();
               // long ret = st.getLong(1);
               long ret = st.getLong(1);
               rs.close();
               st.close();

View Full Code Here

Examples of java.sql.CallableStatement.registerOutParameter()

               String test = "this is a simple base64 encoding test for clobs";
               st.setString(2, "BASE64_ENC_CLOB");
               st.setString(3, test);
               st.setString(4, "unused");
               st.setLong(5, 1L); // loop only once
               st.registerOutParameter(1, Types.CLOB);
               ResultSet rs = st.executeQuery();
               Clob clob = st.getClob(1);
               long len = clob.length();
               byte[] buf = new byte[(int)len];
               clob.getAsciiStream().read(buf);

View Full Code Here

Examples of java.sql.CallableStatement.registerOutParameter()

               String test = "this is a simple test string for the fill_blob_char";
               st.setString(2, "FILL_BLOB_CHAR2");
               st.setString(3, test);
               st.setString(4, "fill");
               st.setLong(5, 1L); // loop only once
               st.registerOutParameter(1, Types.CLOB);
               ResultSet rs = st.executeQuery();
               Clob clob = st.getClob(1);
               long len = clob.length();
               byte[] buf = new byte[(int)len];
               clob.getAsciiStream().read(buf);

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.