显示PL/SQL功能警告 [英] Display PL/SQL function warnings

问题描述

我具有以下功能:

CREATE OR REPLACE Function pode_levar( pedidos NUMBER, viagens  NUMBER)
   RETURN NUMBER
IS
x NUMBER:=0;
y NUMBER:=0;
TRUE NUMBER:=0;
BEGIN

BEGIN
    Select id_pedido into x
    from pedido
    where id_pedido = pedidos;
    EXCEPTION 
    WHEN NO_DATA FOUND THEN 
    RAISE_APPLICAITON_ERROR(-20305,'PEDIDO TRANSPORTE ENIXISTENTE');
END;

BEGIN
    select lim_vei_vol - volume_total_viagem(viagens)  into y
    from v viagem , ve veiculo
    where v.id_viagem = ve.id_viagem
    and id_viagem = viagens;
    EXCEPTION
    WHEN NO_DATA_FOUND THEN
    TRUE:=0;
    RAISE_APPLICATION_ERROR(-20304,'Viagem Enixistente');
    RETURN(TRUE);
END;

BEGIN 
    IF y <> 0 
    TRUE := 1;
    RETURN(TRUE);
    ELSE
    TRUE := 0;
    RETURN(TRUE);
    ENDIF;

END;

END;

该函数编译时只有一个警告，我怎么看? show errors不起作用

The function compiles with one warning, how can I see it? show errors does not work

这是上学的

推荐答案

您应该使用SQL * Plus并进行设置

You should use SQL* Plus and set

ALTER SESSION SET PLSQL_WARNINGS = 'ENABLE:ALL';

在创建函数之前.此设置将通过使用

before you create your function. This setting will show you any warnings by using

SHOW ERRORS;

阅读: http://docs.oracle. com/cd/B28359_01/server.111/b28320/initparams186.htm#REFRN10249

这篇关于显示PL/SQL功能警告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！