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:

Share your thoughts Join the conversation, ask follow-up questions, or add your experience related to this post.

Post a Comment