5 Replies Latest reply: Mar 13, 2012 1:25 AM by Gary Graham-Oracle RSS

    SQL Error: Stream has already been closed using SQLDev 3.1

    Kgronau-Oracle
      When I create in Oracle (11.2.0.3) this table:
      drop table DATA_Stream_Error;
      CREATE TABLE DATA_Stream_Error
      (
      DATA_ID NUMBER NOT NULL ENABLE,
      DATA_DESC LONG,
      DATA_CREATE_DT DATE );

      insert a row:
      insert into data_stream_error values (1,'Test',sysdate);
      commit;

      And now try to select from this table using SQL Developer 3.1
      select * from DATA_Stream_Error;

      I get:

      DATA_ID DATA_DESC DATA_CREATE_DT
      ------- -------------------------------------------------------------------------------- --------------

      Error starting at line 9 in command:
      select * from DATA_Stream_Error
      Error report:
      SQL Error: Stream has already been closed



      This was working in SQL Developer 3.0.
      Is there a setting to change to get it working again in SQL Dev 3.1?