DECLARE
lv_user_name varchar2(50) :='&user_name';
lv_password varchar2(30) :='&password';
lv_session_id integer := userenv('sessionid');
BEGIN
fnd_user_pkg.createuser(x_user_name => lv_user_name,
x_owner => NULL,
x_unencrypted_password => lv_password,
x_session_number => lv_session_id,
x_start_date => sysdate,
x_end_date => NULL,
x_email_address => NULL
);
DBMS_OUTPUT.put_line('User:' || lv_user_name || 'Created Successfully');
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.put_line('Unable to create User due to' || SQLCODE || ' ' || SUBSTR(SQLERRM, 1, 100));
END;
lv_user_name varchar2(50) :='&user_name';
lv_password varchar2(30) :='&password';
lv_session_id integer := userenv('sessionid');
BEGIN
fnd_user_pkg.createuser(x_user_name => lv_user_name,
x_owner => NULL,
x_unencrypted_password => lv_password,
x_session_number => lv_session_id,
x_start_date => sysdate,
x_end_date => NULL,
x_email_address => NULL
);
DBMS_OUTPUT.put_line('User:' || lv_user_name || 'Created Successfully');
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.put_line('Unable to create User due to' || SQLCODE || ' ' || SUBSTR(SQLERRM, 1, 100));
END;
No comments:
Post a Comment