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也不起作用.

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()不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！