输出消息问题与程序和功能 [英] Output message problems with procedure and function

问题描述

我已经成功创建了一个函数和一个触发器，但是输出似乎没有显示，当我执行它只是说程序成功完成。它不显示总成本。

I have successfully created a function and a trigger but the output does not seem to be showing when i execute it just says procedure completed successfully. It does not display the total cost.

推荐答案

要查看DBMS_OUTPUT包的输出，必须启用它。这取决于您使用的工具。

To see the output from the DBMS_OUTPUT package, you must enable it. That depends on the tool you are using.

• 在SQL +中，设置命令 set serveroutput on 在TOAD中运行过程


• 之前，在SQL Developer中单击DBMS_OUTPUT选项卡中的Output On / Off按钮


• 名为DBMS_OUTPUT的标签，单击第一个图标以启用输出

• in SQL+, set the command set serveroutput on before running the procedure
• in TOAD, click on the Output On/Off button in the DBMS_OUTPUT tab
• in SQL Developer you also have a tab named DBMS_OUTPUT, click on the the first icon to enable the output

这篇关于输出消息问题与程序和功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！