问题描述
我试图将传递给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也不起作用.
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过程"之前打印"test".
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()不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！