Skip to main content
Solved

how to change value in event action

  • November 11, 2021
  • 2 replies
  • 668 views

Forum|alt.badge.img+5

hi,

 

i have a event action on “PROJECT_TRANSACTION_TAB”.

i want to update :NEW.REPORT_COST_CODE value but icant do it.

i think standart oracle trigger syntax wont work.

how can i do it?

 thanks

 

Best answer by aykuty

thank you Randini 

View original
Did this topic help you find an answer to your question?

2 replies

Randini Jayasundara
Superhero (Employee)
Forum|alt.badge.img+12

Hi @aykuty 

Please go through the reply given in below post and check whether a similar thing is applicable in your scenario as well.

 

In your case the Step 2 event action should be as follows.

DECLARE

   Arge_Durum_   VARCHAR2(20);

   attr_ VARCHAR2(2000);

   info_ VARCHAR2(2000);

   objid_ VARCHAR2(2000);

   objversion_ VARCHAR2(2000);

CURSOR get_rec IS

   SELECT rowid, to_char(rowversion,'YYYYMMDDHH24MISS')

   FROM  project_transaction_tab

   WHERE project_transaction_seq = '&PROJECT_TRANSACTION_SEQ';

BEGIN

   -- Get the value of Arge_Durum_ as per your requirement

   OPEN get_rec;

   FETCH get_rec INTO objid_, objversion_;

   CLOSE get_rec;

   Client_SYS.Clear_Attr(attr_);

   Client_SYS.Add_To_Attr('REPORT_COST_CODE',   Arge_Durum_,   attr_);

   Project_Transaction_API.Modify__(info_,  objid_, objversion_, attr_, 'DO');

END;


Forum|alt.badge.img+5
  • Author
  • Do Gooder
  • 9 replies
  • Answer
  • December 30, 2021

thank you Randini 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings