Thursday, October 11, 2012

To Change User Password through Backend

DECLARE
BEGIN
   BEGIN
      IF fnd_user_pkg.changepassword('XIBMO59', 'ram1234')
      THEN
         DBMS_OUTPUT.put_line(' Password Changed Successfully');
      END IF;
   EXCEPTION
      WHEN OTHERS
      THEN
         DBMS_OUTPUT.put_line('Error Occured');
   END;
END;

No comments:

Post a Comment