Home » SQL & PL/SQL » Client Tools » Trying to open the XML (CLOB Data) from a table. Getting "out of Memory" error in plsql developer to
Trying to open the XML (CLOB Data) from a table. Getting "out of Memory" error in plsql developer to [message #657017] Wed, 26 October 2016 04:48 Go to next message
msyogi
Messages: 12
Registered: May 2016
Location: Hyderabad
Junior Member
Trying to open the XML (CLOB Data) from a table. Getting "out of Memory" error in plsql developer tool. Please help how to open the xml CLOB without error.
We have tried spooling and running the query from command prompt but still not reading the whole page.

And also we dont have access to create a directory to save it in a server as it is prod db
Re: Trying to open the XML (CLOB Data) from a table. Getting "out of Memory" error in plsql developer to [message #657019 is a reply to message #657017] Wed, 26 October 2016 05:22 Go to previous messageGo to next message
cookiemonster
Messages: 12961
Registered: September 2008
Location: Rainy Manchester
Senior Member
is the out of memory error an oracle error or a plsql developer specific error?
Re: Trying to open the XML (CLOB Data) from a table. Getting "out of Memory" error in plsql developer to [message #657021 is a reply to message #657019] Wed, 26 October 2016 05:38 Go to previous messageGo to next message
msyogi
Messages: 12
Registered: May 2016
Location: Hyderabad
Junior Member
It is a plsql developer error.
Re: Trying to open the XML (CLOB Data) from a table. Getting "out of Memory" error in plsql developer to [message #657025 is a reply to message #657021] Wed, 26 October 2016 06:41 Go to previous messageGo to next message
cookiemonster
Messages: 12961
Registered: September 2008
Location: Rainy Manchester
Senior Member
Try closing any other open programs then, if not you probably need more RAM
Re: Trying to open the XML (CLOB Data) from a table. Getting "out of Memory" error in plsql developer to [message #657028 is a reply to message #657017] Wed, 26 October 2016 07:57 Go to previous messageGo to next message
joy_division
Messages: 4803
Registered: February 2005
Location: East Coast USA
Senior Member
msyogi wrote on Wed, 26 October 2016 05:48

We have tried spooling and running the query from command prompt but still not reading the whole page.
So then it not a SQL Developer issue.
Re: Trying to open the XML (CLOB Data) from a table. Getting "out of Memory" error in plsql developer to [message #657035 is a reply to message #657028] Wed, 26 October 2016 08:29 Go to previous messageGo to next message
cookiemonster
Messages: 12961
Registered: September 2008
Location: Rainy Manchester
Senior Member
I imagine the sqlplus issue can be solved with:

set long 50000

or higher.
Re: Trying to open the XML (CLOB Data) from a table. Getting "out of Memory" error in plsql developer to [message #657039 is a reply to message #657035] Wed, 26 October 2016 10:28 Go to previous messageGo to next message
msyogi
Messages: 12
Registered: May 2016
Location: Hyderabad
Junior Member
We tried set long more than 50000, but no use.
And about RAM, we have already 4GB configured. Please suggest. Thanks
Re: Trying to open the XML (CLOB Data) from a table. Getting "out of Memory" error in plsql developer to [message #657040 is a reply to message #657039] Wed, 26 October 2016 10:36 Go to previous messageGo to next message
Michel Cadot
Messages: 65256
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

And did you try "higher"?
There's no relation between the error and SQL*Plus, it is a pure plsql developer and you should not have it with SQL*Plus.
If you have it (or any other one) then copy and paste your SQL*Plus session.
Before, Please read How to use [code] tags and make your code easier to read.
Also always post your Oracle version, with 4 decimals, for both database and SQL*Plus.
And set SQl*Plus with:
set linesize 100 trimout on trimspool on long 1000000 longchunksize 100

Re: Trying to open the XML (CLOB Data) from a table. Getting "out of Memory" error in plsql developer to [message #657041 is a reply to message #657039] Wed, 26 October 2016 10:38 Go to previous messageGo to next message
cookiemonster
Messages: 12961
Registered: September 2008
Location: Rainy Manchester
Senior Member
I have no idea how much RAM you would need.
How long is this clob?
Re: Trying to open the XML (CLOB Data) from a table. Getting "out of Memory" error in plsql developer to [message #657042 is a reply to message #657041] Wed, 26 October 2016 10:44 Go to previous messageGo to next message
Michel Cadot
Messages: 65256
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

SQL*Plus reads the CLOB in chunks not as a whole, it needs no special added memory for this.

Re: Trying to open the XML (CLOB Data) from a table. Getting "out of Memory" error in plsql developer to [message #657043 is a reply to message #657017] Wed, 26 October 2016 11:18 Go to previous message
BlackSwan
Messages: 25751
Registered: January 2009
Location: SoCal
Senior Member
>"out of Memory"
above is Windows error; not Oracle error
Previous Topic: Error 6 initializing SQL*Plus
Next Topic: Help on passing variables.
Goto Forum:
  


Current Time: Mon Dec 18 01:31:57 CST 2017

Total time taken to generate the page: 0.01810 seconds