Error: Crash (disappear) executing SQL Statement with large CLOB return

[briburke]

Hi,

I'm having a strange problem with PL/SQL Developer. I'm executing a SQL statement in a SQL Window that creates a large XML document, and returns it into a CLOB. As I add to this statement, the returned XML gets larger. At a certain point the program just crashes (disappears actually - without error messages, etc.) when I execute the longer statement.

This is consistently repeatable every time I execute the longer statement.

Largest successfull return: 972322 characters

Version info:
Oracle Enterprise: 9.2.0.1.0
OCI version: 8.1
PL/SQL version: 5.1.2.687 01.15527
Windows XP Pro SP1

Thanks,
Brian

 

[Marco Kalter]

Can you create something that reproduces this problem and send it to me by e-mail?

------------------
Marco Kalter
Allround Automations

 

[gulhaugen]

I posted something along these lines a few months ago. I didn't hear anything after a few emails back and forth.

Maybe you should look that up again.

I will see what I find.

 

[gulhaugen]

I have found the emails, if I should bundle them and send them again, let me know to whom and with which subject.

Morten

 

[Marco Kalter]

I checked my records, and noticed that you sent an export file with a 16MB BLOB column, which loaded without a problem. In other words, the real problem is that we cannot reproduce this, and that this is most likely a version and/or platform specific Oracle Net bug that simply kills the process.

------------------
Marco Kalter
Allround Automations

 

[briburke]

I changed my code to return a smaller value, which worked fine. My example used about 15 tables out of my schema, so it'd be difficult to demonstrate for you. I'm new to Oracle - can you name a system view or table that would return a *lot* of data that I can write a SQL statement against?

-Brian