oracle 调试时如何在TOAD中查看CLOB变量的完整值
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/15240926/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
how to see complete value of CLOB variable in TOAD while debugging
提问by Darshan
In Packages , how can I see complete value of clob variable in debug mode on toad. Currently if I click on add watch on clob varibale and go to modify it shows only "open=F, temp=T, length=354, chunksize=8132, data=
在 Packages 中，如何在 toad 的调试模式下查看 clob 变量的完整值。目前，如果我在 clob varibale 上单击 add watch 并修改它只显示“open=F，temp=T，length=354，chunksize=8132，data=
回答by Egor Skriptunoff
Try watching to_char(your_clob_var)
试试看 to_char(your_clob_var)
EDIT :
Unfortunately, TOAD seems to accept only variables to be watched or inspected.
You can't watch expression like n+1or to_char(clob_var).
But when watching clob you see full information about it including its text:
编辑：
不幸的是，TOAD 似乎只接受要观察或检查的变量。
你不能看像n+1或 的表情to_char(clob_var)。
但是在观看 clob 时，您会看到有关它的完整信息，包括其文本：
Scope Owner Name Expression Value
Local SCHEMA_NAME PROCEDURE_NAME clob_var open=F, temp=T, length=7, chunksize=16324, data=String_inside_this_clob
open=F, temp=T, length=354, chunksize=8132, data=means text starts with LFchar :-) . Go to menu Debug -> Evaluate/Modify (Ctrl+Alt+E)to view full text.
open=F, temp=T, length=354, chunksize=8132, data=表示文本以LFchar :-)开头。进入菜单Debug -> Evaluate/Modify (Ctrl+Alt+E)查看全文。
