Advertisement
Guest User

Untitled

a guest
Aug 16th, 2017
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. declare
  2. success int;
  3. msg varchar(100);
  4. begin
  5. SYS.CHANGEPASSWORD@abc(
  6. PUSERNAME => :P15_UNAME,
  7. PNEWPASSWORD => :P15_NEW,
  8. PRESULT => success,
  9. PMESSAGE => msg);
  10. if success = 0 then
  11. apex_application.g_print_success_message := msg;
  12. else
  13. apex_application.g_print_success_message := '<span style="color:red">' || msg || '</span>';
  14. end if ;
  15. end ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement