Oracle9iAS Portal Developer Kit
PL/SQL APIs - What's New?

- What's new in Oracle9iAS Portal 9.0.2
- What's new in Oracle Portal 3.0.9
- What's new in Oracle Portal 3.0.8

### WHAT'S NEW IN ORACLE9iAS PORTAL 9.0.2

New API packages:

- wwpro_api_progrp_registry (Provider group registration)
- wwpro_api_invalidation (Web cache invalidation)
- wwpro_api_adapter (PL/SQL HTTP adapter)
- wwctx_api_proxy (Proxy setting)
- wwa_app_module (Form component)
- wwa_api_module_session (Form component session)

New scripts:

- provsyns.sql (Provider schema synonym scripts)

Updated API packages:

- wwpro_api_provider_registry
- wwpro_api_provider
- wwsec_api
- wwsec_app_priv
- wwctx_api
- wwnls_api
- wwerr_api_error
- wwerr_api_error_ui
- wwui_api_portlet

Removed in 9.0.2:

- wwpro_api_node_registry
- SNP provider synchronization scripts
- wwsec_api
- wwsec_app_priv
- wwsbr_api
- wwsbr_search_api

Not changed in 9.0.2:

- wwpro_api_parameters
- wwlog_api
- wwlog_api_admin
- wwpre_api_name
- wwpre_api_value
- wwpre_api_util
- wwsto_api_session
- wwui_api_portlet_dialog

wwpro_api_progrp_registry - NEW!!

> - Provider group APIs
> - Provider_group_record
> - register function
> - get_providers function
> - register_provider procedure
> - edit procedure
> - remove procedure
> - get_provider_group_list function
> - find function (ID)
> - find function (name)

wwpro_api_invalidation - NEW !!

> - Web cache invalidation APIs
> - invalidate_by_provider procedure
> - invalidate_by_portlet procedure
> - invalidate_by_user_provider procedure
> - invalidate_by_user_portlet procedure
> - invalidate_by_instance procedure
> - invalidate_cache procedure

wwpro_api_adapter - NEW !!

> - PL/SQL HTTP Adapter APIs
> - is_call_via_adapter function
> - open_form procedure

wwctx_api_proxy - NEW !!

> - Proxy settings APIs
> - proxy_record
> - proxy_info record
> - add_proxy function
> - edit_proxy procedure
> - delete_proxy procedure
> - get_proxy function
> - get_proxy_id function
> - get_proxy_list function
> - get_default_proxy function
> - set_default_proxy procedure
> - get_noproxy_domain function
> - set_noproxy_domain procedure
> - is_proxy_used_by_providers function

wwa_app_module - NEW !!

> - Form component APIs
> - new_instance procedure
> - show procedure
> - link procedure
> - customize procedure
> - show_portlet procedure
> - describe_portlet_parameters function
> - set_target procedure
> - get_target procedure
> - help procedure
> - about procedure
> - file_download procedure

wwa_api_module_session - NEW !!

> - Form component session APIs
> - create_session function
> - load_session function
> - get_session function
> - save_session procedure
> - drop_session procedure
> - get_id function
> - get_module function
> - get_value_as_date function
> - get_value_as_number function
> - get_value_as_varchar2 function
> - get_value_as_string function
> - set_value procedure
> - set_value_as_string procedure
> - set_attribute_default procedure
> - set_row_default procedure
> - copy_attribute_value procedure

provsyns.sql - NEW !!

> - Provider schema synonym scripts

wwpro_api_provider_registry - UPDATED !!

> All references to distributed portals removed due to the introduction of provider groups.

> New fields in provider_record
> - require_session_data
> - is_offline
> - provider_group_id
> - service_id
> - midtier_proxy_hostname
> - midtier_proxy_portnumber
> - dbtier_proxy_hostname
> - dbtier_proxy_portnumber

wwpro_api_provider package - UPDATES !!

> New fields in portlet_record
> - short_title
> - mobile_only
> - show_behaviour_style
> - pass_all_url_params

> New fields in portlet_parameter_record
> - display_name

> New fields in portlet_runtime_record
> - refresh_url
> - has_details
> - has_remove
> - has_collapse
> - is_collasped
> - portlet_template
> - caching_invalidation

wwsec_api - UPDATES !!

> - id function (new parameter p_userguid)
> - id_sso function

wwsec_app_priv - UPDATES !!

> - logout procedure (image)

wwctx_api - UPDATES !!

> - get_company_name
> - get_subscriber_id
> - get_http_language
> - get_nls_territory
> - get_translation_language
> - get_bidi_imagename
> - get_flex_proc_path
> - get_host
> - get_host_lowercase
> - get_direct_doc_path
> - is_session_authenticated
> - is_proxy_required
> - get_session_start_time
> - is_in_login_server
> - get_sso_product_version
> - get_system_var_value
> - get_system_var_names
> - validate_system_var_name
> - set context procedure
> - clear context procedure
> - is_context_set function

wwnls_api - UPDATES !!

> - get_base_string_record
> - copy_string function
> - get_translations (domain, subdomain, name)
> - get_translations (id)
> - http_to_nls procedure
> - get_translation_language function
> - get_preferred_nls_language function
> - get_preferred_http_language function
> - get_preferred_trans_language function
> - get_preferred_territory function
> - is_valid_http_language function
> - is_valid_nls_language function
> - is_valid_territory function
> - territory_from_http_language function
> - db_to_http_territory function
> - is_language_permitted function
> - get_valid_translation_language function

wwerr_api_error - UPDATES !!

> - get_text_stack function
> - get_count function

wwerr_api_error_ui package - UPDATES !!

> - show_xml procedure
> - show_text procedure
> - show_error_page procedure

wwui_api_portlet - UPDATES !!

> New fields in draw_portlet_header procedure
> - p_show_details
> - p_show_edit
> - p_show_help
> - p_show_about
> - p_show_remove
> - p_show_collapse
> - p_is_collapsed
> - p_refresh_url

> New procedures
> - render_portlet_top
> - render_portlet_bottom

Deprecated in 9.0.2

> wwpro_api_node_registry (Node registration APIs) - DEPRECATED !!
> - Provider groups replace node registration functionality.
> - Only the get_local_node_id function remains valid.

> SNP provider synchronization scripts - DEPRECATED !!
> - No longer required, due to the introduction of provider groups.

> wwsec_api (security APIs) - DEPRECATED !!
> - lists function
> - get_list_members function
> - user_in_group function
> - is_group_owner function
> - get_member_record function

> wwsec_app_priv (application privilege APIs) - DEPRECATED !!
> - logout procedure (URL)

Removed in 9.0.2:

> Content Area APIs (wwsbr_api and wwsbr_search_api) available in 3.0.8.x and 3.0.9.x will not work with the initial version of Oracle9iAS Portal 9.0.2 (Version 9.0.2). These APIs will be made available in the next version of Oracle9iAS Portal Release 2, current scheduled for Q3CY2002. This version will also contain scripts to upgrade the 3.0.9 release to Oracle9iAS Portal Release 2.
> - wwsbr_api
> - wwsbr_search_api

### WHAT'S NEW IN ORACLE PORTAL 3.0.9

- Provider API packages
- Content Area API packages
- Security API Packages
- National language support API packages

Provider API packages (wwpro_api_provider)

> New fields in portlet record:
> - call_is_runnable
> - call_get_portlet
> - accept_content_type
> - has_show_link_mode

Content Area API packages (wwsbr_api )

> add item function
> add_item_post_upload function
> modify_item function
> modify_item_post_upload function

Security API packages (wwsec_api & wwsec_app_priv_api)

> New p_reqd_auth_level parameter in:
> has_privilege function
> has_privilege function (one of a list)
> has_privilege function (specified privilege)
> is_privilege_at_least function
> check_privilege function
> check_privilege function (from a list)
> check_privilege function (at least)

National language support API packages (wwnls_api)

> nls_to_http function

### WHAT'S NEW IN ORACLE PORTAL 3.0.8

- Content Area API packages
- UI Portlet Dialog API package
- Preference API package
- Provider registry API package
- Portlet registry synchronization scripts

Content Area API packages (wwsbr_api & wwsbr_search_api)

> add_content_area function
> add_folder function
> add_item function
> submit_search procedure

UI Portlet Dialog API package (wwui_api_portlet_dialog)

> open_dialog procedure
> close_dialog procedure
> create_button function
> create_ok_button function
> create_cancel_button function
> create_apply_button function
> create_next_button function
> create_previous_button function
> create_delete_button function
> create_close_button function
> create_yes_button function
> create_no_button function
> create_create_button function
> create_preview_button function
> create_reset_button function
> create_reset_default_button function

Preference API package (wwpre_api_util)

> get_path_id function
> get_name function
> get_names_table function
> get_values_table function
> copy procedure

Provider registry API package (wwpro_api_provider_registry)

> provider_exist function
> add_portlet_to_repository procedure
> remove_portlet_from_repository procedure
> refresh_portlet_repository procedure

Portlet registry synchronization scripts

> ptljbmng.sql
> ptlrmsyn.sql

###

Revision History:

May 2001