Oracle9iAS Portal Developer Kit

get_product_schema function

Contained in package wwctx_api.

Call this function to get the name of the schema in which Oracle Portal is installed.

function get_product_schema
return varchar2;

Version: Oracle Portal 3.0.6.6.5 or later

Returns:

This function returns the name of the schema in which Oracle Portal is installed.

Exceptions:

This function raises no user-defined exceptions.

Example:

This example returns TRUE if the current Oracle Portal user is the Portal schema owner. It returns FALSE otherwise.

begin

if wwctx_api.get_user = wwctx_api.get_product_schema then

return TRUE;

else

return FALSE;

end if;

end;

Related topics

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