在 Oracle SQL Developer 中执行存储过程
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/4640153/
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
Executing a stored procedure in Oracle SQL Developer
提问by user85917
I am looking for some help in getting the following stored proc to work: I get anonymous block completed and not able to see the result. It works perfectly fine in PL/SQL devloper's "tes" window, but I would like to see it work in the ORACLE SQL Developer
我正在寻找一些帮助来使以下存储的 proc 工作：我完成了匿名块但无法看到结果。它在 PL/SQL devloper 的“tes”窗口中运行良好，但我希望它在 ORACLE SQL Developer 中运行
DECLARE
TYPE OUTPUT_CURSOR IS REF CURSOR
t_c OUTPUT_CURSOR
BEGIN
P_M.E_S.T_S_QUERY( 123,'ABC','20100101','20100131','ALL',:t_c);
END;
回答by Chandu
Make sure you enable the DBMS Output using "View->DBMS Output"and clicking "+"button in the resulting window.
确保使用“查看-> DBMS 输出”并在结果窗口中单击“+”按钮启用 DBMS 输出。
回答by Jithin
In SQL developer we can see the Stored Procedureoutput by enabling DBMS OUTPUT. You can go to VIEW menu and find this option. (Don't forget to enable DBMS output for the desired connection by pressing CTRL+N(the + button))
在 SQL developer 中，我们可以通过启用 DBMS OUTPUT来查看存储过程输出。您可以转到 VIEW 菜单并找到此选项。（不要忘记按CTRL+N（+ 按钮）为所需的连接启用 DBMS 输出）
Hope this makes sense. :)
希望这是有道理的。:)
