SQLDeveloper不在调试模式下启动 [英] SQLDeveloper Does not start in debug mode

问题描述

我试图在调试模式下运行sql developer，但出现以下错误.我关闭了Windows计算机上的防火墙. (我认为我的防病毒防火墙仍处于打开状态，我不确定是否会造成这种情况)

Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( 'xx.xx.xxx.xx', '51814' )
ORA-30683: failure establishing connection to debugger
ORA-12535: TNS:operation timed out
ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: at line 1

什么可能导致此问题?

另一个问题，我是sql develper + PL/SQL开发的新手.我在pl/sql代码中有很多dbms_output.put_line(string)语句.我需要查看它正在打印什么，仅在打开调试器的情况下，它才会显示在sql开发人员日志/控制台中吗?

修改: 如果不需要调试器来打印dbms_output.putline语句，那么我如何运行程序包中已经存在的方法并使其在dbms输出控制台中打印?

解决方案

要查看DBMS_OUTPUT调用的结果，需要在客户端中启用DBMS_OUTPUT.在SQL Developer中，选择视图"->"Dbms输出".在"Dbms输出"窗格中，单击绿色加号以启用输出处理.

(PL/SQL中的DBMS_OUTPUT调用只是将数据放入服务器内存中的缓冲区中.为了真正看到输出，需要告知客户端获取并显示此缓冲区的内容.)

I'm trying to run the sql developer in debug mode and i get the following error. I turned off the firewall on the windows machine. (I think my antiviruses firewall is still turned on, i'm not sure if it causing)

Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( 'xx.xx.xxx.xx', '51814' )
ORA-30683: failure establishing connection to debugger
ORA-12535: TNS:operation timed out
ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: at line 1

What could be causing this issue?

Another Question, i'm new to sql develper+PL/SQL development. I have a lot of dbms_output.put_line(string) statements in the pl/sql code. I need to see what it is printing, does this show up in the sql developer logs/console only if the debugger is turned on?

Edit: If debugger is not required to print the dbms_output.putline statements then how do i run the already existing methods in a package and make it print in the dbms output console?

解决方案

To see the results of your DBMS_OUTPUT calls, you need to enable DBMS_OUTPUT in the client. In SQL Developer, select View -> Dbms Output. In the Dbms Output pane, click the green plus sign to enable output processing.

(The DBMS_OUTPUT calls in PL/SQL simply put data into a buffer in memory on the server. In order to actually see the output, the client needs to be told to fetch and display the contents of this buffer.)

这篇关于SQLDeveloper不在调试模式下启动的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！