Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PLS-00320 - the declaration of the type of this expression is incomplete or

Sandy310Jun 18 2009 — edited Jun 18 2009
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;
This post has been answered by Christian Balz on Jun 18 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 16 2009
Added on Jun 18 2009
2 comments
721 views