This discussion is archived
5 Replies Latest reply: Mar 12, 2012 11:25 PM by Gary Graham RSS

SQL Error: Stream has already been closed using SQLDev 3.1

kgronau Guru
Currently Being Moderated
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?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points