Oracle9iAS Portal Developer Kit

delete_portal_user procedure

Contained in package wwsec_api.

Call this procedure to delete an Oracle Portal user when given a user name.

procedure delete_portal_user

(

p_user_name in varchar2

);

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

p_user_name

The user name of the Oracle Portal user to be deleted.

Datatype: in varchar2

Exceptions:

  • If the user who initiates a calling routine has insufficient authority to execute the routine, an ACCESS_DENIED_EXCEPTION is raised.

  • If the user name is not found, a USER_NOT_FOUND_EXCEPTION is raised.

  • If the user name may not be deleted, a USER_NOT_DELETABLE_EXCEPTION is raised.

Example:

wwsec_api.delete_portal_user

(

p_user_name => 'USER1'

);

Related topics

The PL/SQL API Reference is part of the Portal Developer Kit on Portal Studio