Hi,
Please help me to get rid of this error?
PLS-00320 - the declaration of the type of this expression is incomplete or malformed
PROCEDURE wip_reversal_proc
( p_packing_id IN packing.packing_id%TYPE,
o_return_msg OUT VARCHAR2 )
IS
CURSOR c_packing
IS
SELECT p.client
,p.order_number
,pa.dc
,p.status
,o.status
,o.bo_child_order_id
FROM packing p
,packing_attributes pa
,orders o
WHERE p.packing_id = p_packing_id
AND pa.packing_id = p.packing_id
AND o.client = p.client
AND o.order_number = p.order_number;
------------------------------------------------------------------
-----------------------------MAIN---------------------------------
------------------------------------------------------------------
BEGIN
pack_rec c_packing%ROWTYPE;
OPEN c_packing;
FETCH c_packing
INTO pack_rec;
v_lock := TRUE;
invrec.client := pack_rec.client;