IG Manually processing data

Oracle Application Express is a rapid development tool for Web applications on the Oracle database.
Post Reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

IG Manually processing data

Post by admin »

You might need to process each row of IG manually so the following code will be executed as a loop for each changed row,

Screenshot 2022-11-20 113639.jpg

Code: Select all

begin  
     case :APEX$ROW_STATUS  
     when 'I' then 
         insert into emp ( empno, ename, deptno )  
         values ( :EMPNO, :ENAME, :DEPTNO )  
         returning rowid into :ROWID;  
     when 'U' then  
         update emp  
            set ename  = :ENAME,  
                deptno = :DEPTNO  
          where rowid  = :ROWID;  
     when 'D' then  
         delete emp  
         where rowid = :ROWID;  
     end case;  
end;  
Video related to IG
You do not have the required permissions to view the files attached to this post.
Malik Sikandar Hayat
admin@erpstuff.com
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests