How to encrypt a PL/SQL application in oracle

Question

declare
lc_status:='XXstatus';
Begin
Update xxtable
set Status_fg=lc_status
where con_bill_id=1234;

-- here i need to display how rows were updated.

end;

Answer 1

You can use wrap for the same check these link should be helpful
http://docs.oracle.com/cd/B10500_01/appdev.920/a96624/c_wrap.htm
http://www.dba-oracle.com/teas_prae_util29.htm