Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2004

    Unanswered: How to use oracle 9.2 driver for oracle817's CLOB?

    Now I use Oracle jdbc to deal with oracle 817.Now I use createTemporary method to create C/BLOB.
    I creat C/BLOB and insert into Oracle8,OK.
    But when I select CLOB ,Some exception was threw.
    My method is:
    public String getClobAsString(ResultSet rs, int columnIndex)
            throws SQLException {
            logger.debug("Returning CLOB as string");
            Clob clob = rs.getClob(columnIndex);
            return ((clob != null) ? clob.getSubString(1, (int) clob.length()) : "");

    throwing a "Bigger type length than Maximum" exception.
    If I use oracle817 driver ,The method is ok.But that driver doesn't have temporary method.I want to use this method to insert C/Blob data to database.

    How to use oracle9i driver to select oracle 817 Clob field?
    Last edited by superaxis; 02-16-04 at 10:52.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts