OraFAQ Forum: Client Tools » Trying to open the XML (CLOB Data) from a table. Getting "out of Memory" error in plsql developer to

Home » Other » Client Tools » Trying to open the XML (CLOB Data) from a table. Getting "out of Memory" error in plsql developer to

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

msyogi
Messages: 16
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

Report message to a moderator

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

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

is the out of memory error an oracle error or a plsql developer specific error?

Report message to a moderator

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

msyogi
Messages: 16
Registered: May 2016
Location: Hyderabad

Junior Member

It is a plsql developer error.

Report message to a moderator

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

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

Try closing any other open programs then, if not you probably need more RAM

Report message to a moderator

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

joy_division
Messages: 4963
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.

Report message to a moderator

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

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

I imagine the sqlplus issue can be solved with:

set long 50000

or higher.

Report message to a moderator

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

msyogi
Messages: 16
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

Report message to a moderator

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

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

I have no idea how much RAM you would need.
How long is this clob?

Report message to a moderator

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

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>"out of Memory"
above is Windows error; not Oracle error

Report message to a moderator

Previous Topic:	Error 6 initializing SQL*Plus
Next Topic:	Help on passing variables.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 21 02:20:04 CDT 2025