Hi all,
SQL> set serveroutput on
SQL> CREATE OR replace FUNCTION qty_value(p_item_id IN NUMBER)
2 RETURN NUMBER
3 IS
4 v_qty_arrival NUMBER;
5 BEGIN
6 SELECT CASE
7 WHEN ( SUM (b.quantity) - SUM (b.quantity_received) ) <= 0 THEN 0
8 ELSE ( SUM (b.quantity) - SUM (b.quantity_received) )
9 END Qty_Arrival
10 INTO v_qty_arrival
11 FROM po_lines_all a,
12 po_line_locations_all b
13 WHERE a.po_line_id = b.po_line_id
14 AND a.item_id = p_item_id;
15 EXCEPTION
16 WHEN OTHERS THEN
17 v_qty_arrival := NULL;
18 RETURN v_qty_arrival;
19 END qty_value;
20 /
Function created.
SQL>
SQL> select xxc_qty_arrivale(214960) from dual
2 /
select xxc_qty_arrivale(214960) from dual
*
ERROR at line 1:
ORA-06503: PL/SQL: Function returned without value
ORA-06512: at "APPS.XXC_QTY_ARRIVALE", line 19