sqldeveloper - DBMS_OUTPUT.PUT_LINE() 不起作用 [英] sqldeveloper - DBMS_OUTPUT.PUT_LINE() Doesn't Work
问题描述
我正在尝试将传递给 DBMS_OUTPUT.PUT_LINE() 函数的值打印到 SQL Developer 中的 DBMS_OUTPUT 屏幕.无论我传递给函数什么，都不会在输出窗口中打印任何内容.
I am trying to print the value passed to the DBMS_OUTPUT.PUT_LINE() function to the DBMS_OUTPUT screen in SQL Developer. No matter what I pass to the function, nothing gets printed in the output window.
我打开了 DBMS 输出窗口，甚至连接了可用的连接.但是在运行以下脚本时，脚本输出"窗口中只打印了PL/SQL 过程成功完成"，而 Dbms 输出窗口中则没有.
I have turned on the DBMS Output window and even connected with an available connection. But on running the following script, only "PL/SQL procedure successfully completed" gets printed in the Script Output window, nothing in the Dbms Output window.
此外，我已将缓冲区大小设置为 30000，我想这足以打印字符串 'test'.运行命令 set serveroutput on 也不起作用.
Also I have set the buffer size to 30000, which I guess is enough for printing the string 'test'. Running the command set serveroutput on also didn't work.
当我在命令提示符下在 SQLPlus 中尝试相同的脚本时，它工作正常并在打印PL/SQL 过程成功完成"之前打印测试".
When I try the same script in SQLPlus in the command prompt, it works fine and prints 'test' before printing "PL/SQL procedure successfully completed".
请帮忙.谢谢.
推荐答案
在浏览 Oracle 社区论坛后，我了解到我使用的 SQL Developer 17.x 不提供对 Oracle 10g 的支持.
Upon going through the Oracle community forums, I learned that SQL Developer 17.x which I am using does not provide support to Oracle 10g.
旧版本的 SQL Developer 4.x 将支持 Oracle 10g 并检索 DBMS_OUTPUT 缓冲区以将其显示在屏幕上.
Older version of the SQL Developer 4.x will support Oracle 10g and retrieve DBMS_OUTPUT buffer to display it on the screen.
由于我只为我的家庭作业设置了一个小型数据库并且不想降级到较旧的 SQL Developer，所以我升级到 Oracle 11g XE 并且它工作正常.提供给 DBMS_OUTPUT.PUT_LINE() 过程的所有输入现在都出现在 Dbms 输出窗口中.
Since I only had a small database set up for my homework and did not want to downgrade to an older SQL Developer, I upgraded to Oracle 11g XE and it worked. All input given to DBMS_OUTPUT.PUT_LINE() procedure now appears in the Dbms Output window.
这篇关于sqldeveloper - DBMS_OUTPUT.PUT_LINE() 不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
