begin 

declare
	procedure dyn_sql(p_sql in varchar2) 
	is
	begin
		execute immediate p_sql;
	exception
		when others then
      dbms_output.put_line('===>' ||sqlcode || ' ' || sqlerrm);
			return;
	end;
begin
  if wmp_mode.isClient = true then
    dyn_sql('create table wwnls_strings$ (
    --SUBSCRIBER_ID NUMBER not null,
    --ID NUMBER not null,
    DOMAIN VARCHAR2(30) not null,
    SUB_DOMAIN VARCHAR2(32) not null,
    NAME VARCHAR2(64) not null,
    LANGUAGE VARCHAR2(7) not null,
    --TEXT LONG,
    --TEXT_START VARCHAR2(256),
    --BASE_STRING_ID number,
    TEXT_STRING VARCHAR2(4000),
    unique (DOMAIN, SUB_DOMAIN, NAME, LANGUAGE)
    )
    ');  
  else
  	dyn_sql('create synonym wwnls_api for ~portalSchema.wwnls_api');
  	dyn_sql('create synonym wwnls_strings$ for ~portalSchema.wwnls_strings$');
  	dyn_sql('create synonym wwv_settingsdb for ~portalSchema.wwv_settingsdb');
    dyn_sql('create synonym wwv_settingssets for ~portalSchema.wwv_settingssets');
  	dyn_sql('create synonym wwv_setting for ~portalSchema.wwv_setting');
    dyn_sql('create synonym wwpob_style$ for ~portalSchema.wwpob_style$');
  	dyn_sql('create synonym wwsec_oid for ~portalSchema.wwsec_oid');
    dyn_sql('create synonym wwsec_api for ~portalSchema.wwsec_api');
  	dyn_sql('create synonym wwsec_group$ for ~portalSchema.wwsec_group$');
    dyn_sql('create synonym wwsec_group for ~portalSchema.wwsec_group');
  	dyn_sql('create synonym wwsec_ui for ~portalSchema.wwsec_ui');
    dyn_sql('create synonym wwsec_validation for ~portalSchema.wwsec_validation');
  	dyn_sql('create synonym wwsec_api_private for ~portalSchema.wwsec_api_private');
    dyn_sql('create synonym wwsec_app_priv for ~portalSchema.wwsec_app_priv');
    dyn_sql('create synonym wwsec_person for ~portalSchema.wwsec_person');
    dyn_sql('create synonym wwv_utlglobl for ~portalSchema.wwv_utlglobl');
    dyn_sql('create synonym wwv_standard_util for ~portalSchema.wwv_standard_util');
    dyn_sql('create synonym wwctx_api for ~portalSchema.wwctx_api');
  	dyn_sql('create synonym wwsec_api for ~portalSchema.wwsec_api');
    dyn_sql('create synonym wwnls_api for ~portalSchema.wwnls_api');
  	dyn_sql('create synonym wwerr_api_error for ~portalSchema.wwerr_api_error');
    dyn_sql('create synonym wwerr_api_error_ui for ~portalSchema.wwerr_api_error_ui');
  	dyn_sql('create synonym wwsto_api for ~portalSchema.wwsto_api');
    dyn_sql('create synonym wwpre_api_name for ~portalSchema.wwpre_api_name');
  	dyn_sql('create synonym wwpre_api_value for ~portalSchema.wwpre_api_value');
    dyn_sql('create synonym wwlog_api for ~portalSchema.wwlog_api');
  	dyn_sql('create synonym wwpro_api_provider for ~portalSchema.wwpro_api_provider');
    dyn_sql('create synonym wwpro_api_parameters for ~portalSchema.wwpro_api_parameters');
  	dyn_sql('create synonym wwpro_api_provider_registry for ~portalSchema.wwpro_api_provider_registry');
    dyn_sql('create synonym wwpob_api_page for ~portalSchema.wwpob_api_page');
  	dyn_sql('create synonym wwpob_api_style for ~portalSchema.wwpob_api_style');
    dyn_sql('create synonym wwui_api_portlet for ~portalSchema.wwui_api_portlet');
  	dyn_sql('create synonym wwutl_htp for ~portalSchema.wwutl_htp');
    dyn_sql('create synonym wwutl_htf for ~portalSchema.wwutl_htf');
 	dyn_sql('create synonym wwpob_app_style for ~portalSchema.wwpob_app_style');
  end if;
  
exception
	when others
	then
		null;
end;

end;