Print Thread
Buffer in spawned session from running session
#48324 12/10/13 08:18 PM
Joined: Aug 2003
Posts: 101
Chesapeake Bay
Member
OP Offline
Member
Joined: Aug 2003
Posts: 101
Chesapeake Bay
While trying to debug a program I am kicking off a "child" session using SQL window and trying to look at the data.
unfortunately, as i have to deal with the table of more then 60 columns i am getting ORA - 6558 buffer in dbms_pipe is full.
Now - that is of course not PL/SQL error. However, when i decrease amount of columns to about 10 I get ora - 6502.
Can you please look into that 6502 ?

(it appears that your grid misreading statement for the datatypes)

Re: Buffer in spawned session from running session
null0000 #48331 12/11/13 10:32 AM
Joined: Aug 1999
Posts: 22,487
Member
Offline
Member
Joined: Aug 1999
Posts: 22,487
To obtain some more diagnostic information, can you modify the shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\<User>\AppData\Roaming\PLSQL Developer).


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.032s Queries: 14 (0.006s) Memory: 2.4982 MB (Peak: 3.0399 MB) Data Comp: Off Server Time: 2024-12-04 05:59:21 UTC
Valid HTML 5 and Valid CSS