Hello

I have an odd error. When I execute the following SQL:

1 SELECT
2 PF.FILENAME
3 ,PF.ESTAB
4 ,PF.DATA_COLLECTION_FK
5 ,PF.PROCESS_FILE_PK
6 ,TO_CHAR(PF.DATE_PROCESS, 'ddth Mon YYYY HH24:MI:SS') DATE_PROCESS
7 ,TO_CHAR(PF.FILE_DATE, 'ddth Mon YYYY') FILE_DATE
8 ,SBD.SCHOOL_NAME
9 ,TO_CHAR(LNF.DATE_MODIFIED, 'YYYY-DD-MM HH24:MI:SS') DATE_MODIFIED
10 ,LNF.NOTE_TEXT
11 ,LNF.AUTHOR
12 ,LNF.COLLECTION_NOTE_PK
13 ,FE.FATAL_ERRORS
14 ,ER.ERRORS
15 ,PF.PROCESS
16 FROM
17 PROCESS_FILE PF
18 ,SUBJECT_BASIC_DATA SBD
19 ,DATA_COLLECTION DC
20 ,V_LATEST_NOTE_FULL_CEN06 LNF
21 ,V_COMBINED_ERROR_COUNT_FATAL FE
22 ,V_COMBINED_ERROR_COUNT_QUERY ER
23 ,V_HIGHEST_PROCESS HP
24 WHERE
25 PF.DATA_COLLECTION_FK = DC.DATA_COLLECTION_PK
26 AND DC.DESCRIPTION IN ('Data Coll 1','Data Coll 2')
27 AND PF.ESTAB = SBD.ESTAB
28 AND PF.ESTAB = LNF.ESTAB_FK(+)
29 AND PF.DATA_COLLECTION_FK = LNF.DATA_COLLECTION_FK(+)
30 AND PF.PROCESS_FILE_PK = FE.PROCESS_FILE_FK(+)
31 AND PF.PROCESS_FILE_PK = ER.PROCESS_FILE_FK(+)
32 AND PF.FILENAME = HP.FILENAME
33 AND PF.PROCESS = HP.MAX_PROCESS;


my java code fails when I try to read the value of NOTE_TEXT(line 10). with the following error:

Exception in thread "main" java.sql.SQLException: Io exception: execution completed with warning
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:134)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:179)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:333)
        at oracle.jdbc.ttc7.LongTTCItem.getChars(LongTTCItem. java:200)
        at oracle.jdbc.dbaccess.DBDataSetImpl.getCharsStreamI tem(DBDataSetImpl.java:1630)
        at oracle.jdbc.driver.OracleStatement.getCharsInterna l(OracleStatement.java:3347)
        at oracle.jdbc.driver.OracleStatement.getStringValue( OracleStatement.java:3556)
        at oracle.jdbc.driver.OracleResultSetImpl.getString(O racleResultSetImpl.java:434)
        at oracle.jdbc.driver.OracleResultSet.getString(Oracl eResultSet.java:1482)

NOTE_TEXT is a LONG/CLOB field

However, when I remove references to the linked view V_HIGHEST_PROCESS (lines 23, 32, and 33), which are not related to the field NOTE_TEXT at all but are used to filter the results, the data can be retrieved with no problems

Does anyone know why this is occurring? Fearing it to be a fault in the Oracle JDBC drivers, I have tried putting my query into a view, but I get the same error.

Thanks in advance

holdmykidney