Link to home
Start Free TrialLog in
Avatar of MichBman
MichBmanFlag for United States of America

asked on

How do I call a Oracle Stored Proc from a Insert Trigger

II created an insert trigger on a table that needs to call a stored proc to update the coresponding record on another table.  I get a PLS-00049 : bad bind value variable 'P'
TRIGGER TRI_DD200APPROVALACTIONS 
AFTER INSERT ON DD200APPROVALACTIONS 
 FOR EACH ROW 
DECLARE
  P NUMBER;
BEGIN
  IF INSERTING THEN
  
      P := :new.DDAPPVACTID;
      
      Trig_UpdFLIPLSig(:P);

  END IF;
  
  END;

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of sventhan
sventhan
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of MichBman
MichBman
Flag of United States of America image

ASKER

I removed the : infront of the P and it worked.
Avatar of sventhan
sventhan
Flag of United States of America image
@MichBman -

Is there anything wrong with my answer and the reference link? I've give you the exact answer and I cannot accept your comments.

Thanks,

~sve.
Avatar of South Mod
South Mod
Flag of United States of America image
All,
 
Following an 'Objection' by sventhan (at https://www.experts-exchange.com/questions/26700021/27-Dec-10-20-Automated-Request-for-Review-Objection-to-Delete-Q-26699874.html) to the intended closure of this question, it has been reviewed by at least one Moderator and is being closed as recommended by the Expert.
 
At this point I am going to re-start the auto-close procedure.
 
Thank you,
 
SouthMod
Community Support Moderator