cursor with parameter [message #283121] |
Mon, 26 November 2007 03:01  |
senganga
Messages: 15 Registered: November 2007 Location: South Africa
|
Junior Member |

|
|
Hi, Please help me!!!! I want to return a record from my cursor and I am getting the following error Error(9,58): PLS-00201: identifier 'LOAD_TBL' must be declared
This is my function...
CREATE OR REPLACE
FUNCTION FIND_LOAD (p_route_in IN VARCHAR2,
--p_load_rec OUT load_tbl%ROWTYPE
p_Bundles OUT NUMBER,
p_Loose_copies OUT NUMBER,
p_Label_supply OUT NUMBER,
p_Bundles_Pack OUT NUMBER,
p_Roll_pack OUT NUMBER,
p_Number_of_label OUT NUMBER) RETURN load_tbl%ROWTYPE
IS
v_load_rec load_tbl%ROWTYPE;
l_Loose_copies number;
l_Label_supply number;
l_Bundles_Pack number;
l_Roll_pack number;
l_Number_of_label number;
CURSOR load_cur RETURN load_tbl%ROWTYPE
is
select *
from
oe_order_lines_all load_tbl;
BEGIN
OPEN load_cur;
FETCH load_cur INTO v_load_rec;
CLOSE load_cur;
RETURN v_load_rec;
END;
|
|
|
|
|
|
|
|
|
|