Hello,
While debugging a program I setup watches for a few variables and one of them builds a dynamic sql. What is the max size of the value so it is displayed instead of <Value Too Large> message?
Thanks
Suresh
Hello,
While debugging a program I setup watches for a few variables and one of them builds a dynamic sql. What is the max size of the value so it is displayed instead of <Value Too Large> message?
Thanks
Suresh
Usually around 4k characters. This is a limit in the Oracle DBMS_DEBUG package but it’s not a fixed value nor is it documented anywhere. What is actually
returned when we ask Oracle for the watch value is an undocumented error code and an empty value. When we see this, we substitute so you at least have an idea why nothing is displayed.
Hope that helps.
Greg
From: ServiceAccount_Toad [mailto:bounce-ServiceAccount_Toad@toadworld.com]
Sent: Tuesday, December 10, 2013 8:48 AM
Subject: [Toad for Oracle - Discussion Forum] debugging watch value size
Thread created by ServiceAccount_Toad
Hello,
While debugging a program I setup watches for a few variables and one of them builds a dynamic sql. What is the max size of the value so it is displayed
instead of message?
Thanks
Suresh
Attachments:
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
Thanks for your reply Gregory. The size of the value from the dbms_output is 1089 bytes. When I debug the same program in SQL Developer I do see the entire string. It doesn’t look good on TOAD not being able to display when a free tool can. Is there any way that this value can be displayed.
Unfortunately no. SQL Developer uses an entirely different mechanism (JDWP) for their debugging engine. We are using the DEBMS_DEBUG engine provided by Oracle
and we are currently stuck with its limitations.
Greg
From: ssikharam [mailto:bounce-ssikharam@toadworld.com]
Sent: Tuesday, December 10, 2013 9:05 AM
Subject: RE: [Toad for Oracle - Discussion Forum] debugging watch value size
RE: debugging watch value size
Reply by ssikharam
Thanks for your reply Gregory. The size of the value from the dbms_output is 1089 bytes. When I debug the same program in SQL Developer I do see the entire string. It doesn’t look good on
TOAD not being able to display when a free tool can. Is there any way that this value can be displayed.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
Thanks Gregory. Appreciate your quick responses. My concern is I advocated for TOAD and in this particular regard I have to acknowledge the differences and accept the limitations on TOAD side compared to a free tool.