Friday, 5 April 2013

CHANGE THE USERNAME AND PASSWORD IN APPS USING PL/SQL

/* Formatted on 4/5/2013 4:43:11 PM (QP5 v5.114.809.3010) */
DECLARE
   abc   boolean;
BEGIN
   abc := fnd_user_pkg.changepassword ('USERNAME', 'PASSWORD');
EXCEPTION
   WHEN OTHERS
   THEN
      DBMS_OUTPUT.put_line ('error happened' || SQLERRM);
END;

No comments:

Post a Comment