PL/SQL过程已成功完成，但未显示任何内容 [英] PL/SQL procedure succesfully completed but shows nothing

问题描述

我有以下过程代码:

create or replace 
PROCEDURE Ventas_cliente( p_DNI IN CHAR )
IS

  CURSOR c_pedidos_clientes IS
  SELECT *
  FROM Pedidos_venta
  WHERE DNI_Cliente = p_DNI;

BEGIN
  DBMS_OUTPUT.PUT_LINE('test');
  FOR fila IN c_pedidos_clientes LOOP
    DBMS_OUTPUT.PUT_LINE(fila.OID_Pedido_venta||' '||fila.precio);
  END LOOP;
END Ventas_cliente;

当我键入EXECUTE Ventas_(88441020);时，Oracle返回PL/SQL procedure succesfully completed.最大的问题是它将返回测试". Oracle为什么不返回测试"?

When I type EXECUTE Ventas_(88441020); Oracle returns PL/SQL procedure succesfully completed. The great problem is that it'd return 'test'. Why does not Oracle return 'test'?

推荐答案

您需要启用打印到标准输出.

You need to enable printing to stdout.

在SQL * Plus中，最简单的方法是使用

In SQL*Plus the simplest way of doing this is to use serveroutput:

set serveroutput on

这篇关于PL/SQL过程已成功完成，但未显示任何内容的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！