insert into database in dynamic page - Oracle Application Server Portal

I wrote a dynamic page serving as a form to insert into a database table. The problem is most of time (not all the time) it inserts twice. (duplicate row)
It looks like Oracle back end has refreshed the page twice. How can I solve this problem? Any idea?
My code for dynamic page is like this:
<html>
<head>
<script language="javaScript1.1">
function set_insert_mode()
{
frm=document.forms[0];
frm.elements[0].value = "INSERT";
frm.submit();
}
</script>
</head>
<body>
<oracle>Declare
v_mode varchar2(10);
v_pname varchar2(30);
v_desc varchar2(2000);
v_contact varchar2(200);
v_opc_id number;
Begin
v_mode :=Portal30.wwpro_api_parameters.get_value('MODE','DEFAULT');
v_pname :=Portal30.wwpro_api_parameters.get_value('PROJECT_NAME','DEFAULT');
v_desc:= Portal30.wwpro_api_parameters.get_value('DESC','DEFAULT');
v_contact := Portal30.wwpro_api_parameters.get_value('CONTACT','DEFAULT');
v_opc_id :=RTRIM(substr(v_contact,(instr(v_contact,'(')+1)),')');
if v_mode = 'INSERT' then
begin
insert into project(project_name,project_desc,contact)
values(v_pname,v_desc,v_opc_id);
commit;
htp.p('One Row is inserted');
exception
when others then
htp.p(SQLERRM);
end;
end if;
End;
</oracle>
<div align="center">
<form action="" method="post">
<input type="hidden" name="MODE">
<input type="hidden" name="PROJ_ID">
<input type="submit" name="saveBtn" value="Save" onClick="set_insert_mode()">
<BR><BR>
<h3>Part I. General Information</h3>
<table border="0">
<tr><td align="left"><font color=red>Project Name </font></td>
<td align="left"><input type="text" size="30" name="PROJECT_NAME" value=""></td></tr>
<tr><td align="left"><font color=red>Short Description </font></td><td colspan=3 align="left">
<textarea name ="DESC" rows=3 cols=80 wrap="VIRTUAL" onChange="this.value=this.value.substr(0,2000)">
</textarea></td></tr>
<tr><td align="left"><font color=red>Contact </font></td>
<td align="left"><input type="text" size="30" name="CONTACT" value="">
</table>
</form>
</div>
</body>
</html>

Related

Problems with a customized change password JSP

Hi,
I developer a changePassword jsp and made the update at wwsso_ls_configuration_info$.
But when I press some button "OK" or "CANCEL", it returns an error:
"The requested URL /pls/portal30_sso/PORTAL30_SSO.wwsso_app_user_mgr.save_new_password was not found on this server."
The url in the browser after pressing the button is "http://pguida-bra.br.oracle.com/pls/portal30_sso/PORTAL30_SSO.wwsso_app_user_mgr.save_new_password" .
My code jsp is:
<%# page contentType="text/html;charset=ISO-8859-1"
import="oracle.portal.provider.v1.*
,oracle.portal.provider.v1.http.*" %>
<HTML>
<HEAD>
<TITLE>
</TITLE>
</HEAD>
<BODY>
<SCRIPT LANGUAGE="JavaScript1.1">
<!-- Comment out script for old browsers //-->
function button1submit() {  document.ChangePassword.p_action.value = "OK";  document.ChangePassword.submit();  }
function button2submit() {  document.ChangePassword.p_action.value = "CANCEL"; document.ChangePassword.submit();  }
</SCRIPT>
<!--<FORM ACTION="<%=request.getParameter("p_submit_url")%>" METHOD="POST" name="ChangePassword">-->
<FORM ACTION="../../pls/portal30_sso/PORTAL30_SSO.wwsso_app_user_mgr.save_new_password" METHOD="POST" name="ChangePassword">
<!-- <FORM ACTION="PORTAL30SSO.wwsso_app_admin.ls_login" METHOD="POST" name="LoginForm"> -->
<%-- <%= HttpPortletRendererUtil.htmlFormHiddenFields(request,PortletRendererUtil.PAGE_LINK) %> --%>
<INPUT TYPE="hidden" NAME="p_error_code" VALUE="<%=request.getParameter("p_error_code")%>">
<INPUT TYPE="hidden" NAME="p_submit_url" VALUE="<%=request.getParameter("p_submit_url")%>">
<INPUT TYPE="hidden" NAME="p_done_url" VALUE="<%=request.getParameter("p_done_url")%>">
<INPUT TYPE="hidden" NAME="p_pwd_is_exp" VALUE="<%=request.getParameter("p_pwd_is_exp")%>">
<INPUT TYPE="hidden" NAME="site2pstoretoken" VALUE="<%=request.getParameter("site2pstoretoken")%>">
<TABLE WIDTH="90%" BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD>
<FONT CLASS="OraHeaderSub"><NOBR></NOBR></FONT>
<BR>
<FONT CLASS="OraInstructionText"><FONT class="PortletText1">Digite sua senha ATUAL e cadastre a NOVA senha em seguida.</FONT></FONT>
<BR>
<BR>
<TABLE ALIGN="center">
<TR>
<INPUT TYPE="hidden" NAME="p_action" VALUE="">
</TR>
<TR>
<TD><FONT class="PortletHeading1">Conta</FONT></TD>
<TD><INPUT TYPE="text" NAME="p_username" VALUE="<%=request.getParameter("p_username")%>"></TD>
</TR>
<TD><FONT class="PortletHeading1">Senha Atual</FONT></TD>
<TD><INPUT TYPE="password" NAME="p_old_password" SIZE="20" MAXLENGTH="255"></TD>
<TR>
<TD><FONT class="PortletHeading1">Senha Nova</FONT></TD>
<TD><INPUT TYPE="password" NAME="p_new_password" SIZE="20" MAXLENGTH="255"></TD>
</TR>
<TD><FONT class="PortletHeading1">Confirme Senha Nova</FONT></TD>
<TD><INPUT TYPE="password" NAME="p_new_password_confirm" SIZE="20" MAXLENGTH="255"></TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
<CENTER>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0" WIDTH="90%">
<TR>
<TD><IMG SRC="/images/pobtrans.gif" WIDTH="1" HEIGHT="8"></TD>
</TR>
</CENTER>
<TR>
<TD ALIGN="CENTER" VALIGN="TOP">
<TD><INPUT TYPE="button" VALUE="OK" onClick="javascript:button1submit()">
<INPUT TYPE="button" VALUE="CANCEL" onClick="javascript:button2submit()"></TD>
</TD>
</TR>
</TABLE>
</FORM>
</BODY>
</HTML>
Someone knows what's wrong?
Thanks in Advance!

Passing parameters to dynamic page

What am I doing wrong. When I check the buttonsn, thene click the button to pass parameters. I get the error, page connot be found.
<TITLE>Example</TITLE>
</HEAD>
<BODY>
<H2>OnPoint Data Entry</H2>
<form name="Spread_ENTRY" action="http://as2.aultcare.com:7777/pls/portal/AULTCARE.PG_UPDATE_PTRACK.show" method="post">
<table border=1 bordercolor="#CCCCCC">
<tr>
<td>
<td bgcolor="#FFFF66"><font color="#0000FF" size="2">CATEGORY</font></td>
<td bgcolor="#FFFF66"><font color="#0000FF" size="2">CATEGORY DETAILS</font></td>
<td bgcolor="#FFFF66"><font color="#0000FF" size="2">FREQUENCY</font></td>
<td bgcolor="#FFFF66"><font color="#0000FF" size="2">POINTS</font></td>
<td bgcolor="#FFFF66"><font color="#0000FF" size="2">Y/N</font></td>
</tr><ORACLE> begin htp.p('');
htp.p('<input type=hidden name="p_username" value="'||portal.wwctx_api.get_user||'">');
htp.p('<input type=hidden name="p_user_grp" value="'||portal.wwsec_api.group_name(portal.wwsec_api.get_defaultgroup(portal.wwctx_api.get_user))||'">');
for c1 in (select c.category_name,d.id,d.category_type,d.frequency,d.potential_points
from Pointsys.CATEGORY_DETAILS d,pointsys.p_category c
where c.id=d.pcat)
loop
htp.p('<tr><td>');
htp.p('</td><td>');
htp.p(c1.category_name);
htp.p('</td><td>');
htp.p(c1.category_type);
htp.p('</td><td>');
htp.p(c1.frequency);
htp.p('</td><td>');
htp.p(c1.potential_points);
htp.p('</td><td>');
htp.p(' <input type="checkbox" name="p_idtype"
value='''||c1.id||'''>');
htp.p('</td><tr>');
end loop;
htp.p('</table>');
htp.p('<input type="submit" name="Save">');
end;</ORACLE>
</form>
</BODY> </FORM> </HTML> 
Hi, If you format the HTML code text properly, you'll find that there are few unterminated tags (<TABLE>, <TD>, etc.). Further, at the end of the code block there are </BODY></FORM></HTML> tags extra (without corresponding start tags).
Either, you have pasted incomplete code or the above mentioned reason holds and is responsible for the error.
But, the unterminated tags mentioned are surely wrong. I'm not sure if they are the cause of the problem or not.

How to divert to the custom login portlet even for login failure

Hi,
I'm having the following code DB provider’s dynamic page for SSO login mechanism:
<HTML>
<HEAD>
<TITLE>Example</TITLE>
</HEAD>
<BODY>
<H2>Example of A Dynamic Page</H2>
<ORACLE>
DECLARE
v_site2pstoretoken VARCHAR2(5000);
v_submit_url varchar2(1000);
v_site_2_porn_url varchar2(5000);
BEGIN
v_site2pstoretoken :=
PORTAL.wwsec_sso_enabler_private.generate_redirect('host:7778','http://host:7778/portal/page/portal/Ramamuni_PG/Welcome_Page','http://host:7778/portal/page/portal/Ramamuni_PG/Welcome_Page');
v_site2pstoretoken := LTRIM(RTRIM(v_site2pstoretoken));
htp.p('<form action='||v_site2pstoretoken||' method="post" autocomplete="off">');
END;
</ORACLE>
<table>
<tr>
<td>UserId:</td>
<td><input type="text" name="ssousername"/></td>
</tr>
<tr>
<td>Pwd</td>
<td><input type="password" name="password"/></td>
<input type="hidden" name="v" value="v1.4"/>
<INPUT type=hidden name=locale>
</tr>
<tr>
<td><input type="submit" value ="Sign-On" name="submitButton" /></td>
<td><input type="button" value="Cancel" name="submiButton" /></td>
</tr>
</table>
</BODY>
</form>
</HTML>
This is working fine for the authorized users, when a unauthorized/invalid user come then its diverting to the standard SSO login page. My requirement is even for the invalid users the relogin-page might me my portlet with some error message.
I can use the standard SSO login page replacement mechanism, but it won't suits my problem like as there are many applications are deployed in the server and we need to customize them separately.
Please guide me how to achieve this.
Thanks ,
Ravi R

An error wil accour when i choose another tab

Hi.
Ik have a page and within the page i have a report with the following SQL:
-----------------------------------------
select
APEX_ITEM.TEXT(3, ID, NULL, NULL, 'style="display:none"', 'f02_' || LPAD(ROWNUM, 4, '0'))||APEX_KNMG.GET_RADIO_OPTIONS('2', 'f02', 1) test_nummer
from apex_knmg.eval_vragen
-----------------------------------------
The function that the report calls is the following:
------------------------------------------
CREATE OR REPLACE FUNCTION APEX_KNMG."GET_RADIO_OPTIONS"
(
p_VALUE VARCHAR2,
p_ITEM VARCHAR2,
p_ROW NUMBER
)
RETURN VARCHAR2
AS
BEGIN
DECLARE
vHTML VARCHAR2(1000);
vCHECKED VARCHAR2(8);
vITEM VARCHAR2(4);
vNAME VARCHAR2(4);
BEGIN
vITEM := LPAD(p_ROW, 4, '0');
vNAME := LPAD(p_ROW + 1000, 4, '0');
vHTML := '';
FOR i IN 1..5
LOOP
IF NVL(p_VALUE, 1) = i THEN
vCHECKED := 'CHECKED ';
ELSE
vCHECKED := '';
END IF;
vHTML := vHTML || '<input type="radio" name="' || p_ITEM || '_' || vNAME || '" value="' || i || '" ' || vCHECKED || 'onclick="javascript:document.getElementById(''' || p_ITEM || '_' || vITEM || ''').value=this.value;"/> ';
END LOOP;
RETURN vHTML;
END;
------------------------------------------
1- I run the application
2- I go to the page where this SQL code (report - shown above) is running
3- I click on the other tab and i get the following error:
Not Found
The requested URL /pls/otn/wwv_flow.accept was not found on this server.
Oracle-Application-Server-10g/10.1.3.0.0 Oracle-HTTP-Server Server at apex.oracle.com Port 80
Dose anyone know a solutions?
regards 
Shirak,
Most likely the HTML generated was incompatible with the wwv_flow.accept procedure specification. If you post the generated HTML page, we will be able to easily find the problem.
Scott 
<html>
<head>
<meta name="generator" content="HTML Tidy for Java (vers. 26 Sep 2004), see www.w3.org">
<title></title>
<title>Beheer Medewerkers</title>
<link rel="stylesheet" href="/i/themes/theme_20/theme_3_1.css" type="text/css">
<link rel="stylesheet" href="/i/css/apex_3_1.css" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css">
#t20ContentBody{background:url('/i/APPLICATIES/KNMG/gradiant.jpg') top left repeat-x; padding:0 5px}
</style>
<style id="apexir_WORKSHEET_CSS" type="text/css">
</style>
</head>
<body>
Hi Scot, The generated HTML code: --------------------------------------------------------------- <!--[if IE]><link rel="stylesheet" href="/i/themes/theme_20/ie.css" type="text/css" /><![endif]-->
<script src="/i/javascript/apex_ns_3_1.js" type="text/javascript">
</script>
<script src="/i/javascript/apex_3_1.js" type="text/javascript">
</script>
<script src="/i/javascript/apex_get_3_1.js" type="text/javascript">
</script>
<script src="/i/javascript/apex_builder.js" type="text/javascript">
</script>
<script type="text/javascript">
<!--
/*Global JS Variables*/
var htmldb_Img_Dir = "/i/";
//-->
</script>
<!--[if IE]><link rel="stylesheet" href="/i/css/apex_ie_3_1.css" type="text/css" /><![endif]-->
<form action="wwv_flow.accept" method="post" name="wwv_flow" id="wwvFlowForm"><input type="hidden" name="p_flow_id" value="36308" id="pFlowId">
<input type="hidden" name="p_flow_step_id" value="2" id="pFlowStepId">
<input type="hidden" name="p_instance" value="4275735413810994" id="pInstance">
<input type="hidden" name="p_page_submission_id" value="3641588241050783" id="pPageSubmissionId">
<input type="hidden" name="p_request" value="" id="pRequest">
<div id="t20PageHeader">
<table border="0" cellpadding="20" cellspacing="0" summary="">
<tr>
<td id="t20Logo" valign="top"><br>
</td>
<td id="t20HeaderMiddle" valign="top" width="100%"><br>
</td>
<td id="t20NavBar" valign="top" allign="right">Logout |<br>
</td>
</tr>
</table>
<table id="t20Tabs" border="0" cellpadding="0" cellspacing="0" summary="">
<tr>
<td><img src="/i/themes/theme_20/topDimTabL.gif">
</td>
<td class="t20Tab">Formulier</td>
<td><img src="/i/themes/theme_20/topDimTabR.gif">
</td>
<td>?</td>
<td><img src="/i/themes/theme_20/topTabL.gif">
</td>
<td class="t20CurrentTab">Beheer?Medewerkers</td>
<td><img src="/i/themes/theme_20/topTabR.gif">
</td>
<td>?</td>
<td><img src="/i/themes/theme_20/topDimTabL.gif">
</td>
<td class="t20Tab">Rapport?vragenlijst</td>
<td><img src="/i/themes/theme_20/topDimTabR.gif">
</td>
<td>?</td>
<td><img src="/i/themes/theme_20/topTabL.gif">
</td>
<td class="t20CurrentTab">Beheer?medewerkers?nieuw</td>
<td><img src="/i/themes/theme_20/topTabR.gif">
</td>
<td>?</td>
<td><img src="/i/themes/theme_20/topDimTabL.gif">
</td>
<td class="t20Tab">TestTab</td>
<td><img src="/i/themes/theme_20/topDimTabR.gif">
</td>
<td>?</td>
</tr>
</table>
</div>
<div id="t20BreadCrumbsLeft"></div>
<table border="0" cellpadding="0" cellspacing="0" summary="" id="t20PageBody" width="100%" height="70%">
<tr>
<td width="100%" valign="top" id="t20ContentBody">
<div id="t20Messages"></div>
<div id="t20ContentMiddle">
<div id="apexir_WORKSHEET_REGION" class="apex_worksheet">
<div id="apexir_DETAIL" class="apex_detail"></div>
<div id="apexir_REPORT" class="apex_report">
<div id="apexir_TOOLBAR" class="apex_toolbar"></div>
<div id="apexir_WORKSHEET">
<div id="apexir_CONTROL_PANEL_DROP" class="drop_panel clearfix" style="display:none"></div>
<input type="hidden" id="apexir_WORKSHEET_ID" value="4025269025511872024">
<input type="hidden" id="apexir_APP_USER" value="APEX_PUBLIC_USER">
<input type="hidden" id="apexir_REPORT_ID" value="4025269326065872949">
<div>
<div id="apexir_CHART"></div>
<div id="apexir_CALENDAR"></div>
<div id="apexir_DATA_PANEL">
<table summary="">
<tr>
<td><script type="text/javascript">
var gTable = '4025269025511872024'
</script>
<table summary="" cellpadding="0" cellspacing="0" border="0" class="apexir_WORKSHEET_DATA" id="4025269025511872024">
<tr>
<th>
<div id="apexir_TEST_NUMMER" style="text-align:center;">Test Nummer</div>
</th>
</tr>
<tr>
<td align="left"><input type="text" name="f03" size="20" maxlength="2000" value="1" style="display:none" id="f02_0001">
<input type="radio" name="f02_1001" value="1">
<input type="radio" name="f02_1001" value="2" checked>
<input type="radio" name="f02_1001" value="3">
<input type="radio" name="f02_1001" value="4">
<input type="radio" name="f02_1001" value="5">
</td>
</tr>
<tr>
<td align="left"><input type="text" name="f03" size="20" maxlength="2000" value="2" style="display:none" id="f02_0002">
<input type="radio" name="f02_1001" value="1">
<input type="radio" name="f02_1001" value="2" checked>
<input type="radio" name="f02_1001" value="3">
<input type="radio" name="f02_1001" value="4">
<input type="radio" name="f02_1001" value="5">
</td>
</tr>
<tr>
<td align="left"><input type="text" name="f03" size="20" maxlength="2000" value="3" style="display:none" id="f02_0003">
<input type="radio" name="f02_1001" value="1">
<input type="radio" name="f02_1001" value="2" checked>
<input type="radio" name="f02_1001" value="3">
<input type="radio" name="f02_1001" value="4">
<input type="radio" name="f02_1001" value="5">
</td>
</tr>
<tr>
<td align="left"><input type="text" name="f03" size="20" maxlength="2000" value="4" style="display:none" id="f02_0004">
<input type="radio" name="f02_1001" value="1">
<input type="radio" name="f02_1001" value="2" checked>
<input type="radio" name="f02_1001" value="3">
<input type="radio" name="f02_1001" value="4">
<input type="radio" name="f02_1001" value="5">
</td>
</tr>
<tr>
<td align="left"><input type="text" name="f03" size="20" maxlength="2000" value="5" style="display:none" id="f02_0005">
<input type="radio" name="f02_1001" value="1">
<input type="radio" name="f02_1001" value="2" checked>
<input type="radio" name="f02_1001" value="3">
<input type="radio" name="f02_1001" value="4">
<input type="radio" name="f02_1001" value="5">
</td>
</tr>
<tr>
<td align="left"><input type="text" name="f03" size="20" maxlength="2000" value="6" style="display:none" id="f02_0006">
<input type="radio" name="f02_1001" value="1">
<input type="radio" name="f02_1001" value="2" checked>
<input type="radio" name="f02_1001" value="3">
<input type="radio" name="f02_1001" value="4">
<input type="radio" name="f02_1001" value="5">
</td>
</tr>
<tr>
<td align="left"><input type="text" name="f03" size="20" maxlength="2000" value="7" style="display:none" id="f02_0007">
<input type="radio" name="f02_1001" value="1">
<input type="radio" name="f02_1001" value="2" checked>
<input type="radio" name="f02_1001" value="3">
<input type="radio" name="f02_1001" value="4">
<input type="radio" name="f02_1001" value="5">
</td>
</tr>
<tr>
<td align="left"><input type="text" name="f03" size="20" maxlength="2000" value="8" style="display:none" id="f02_0008">
<input type="radio" name="f02_1001" value="1">
<input type="radio" name="f02_1001" value="2" checked>
<input type="radio" name="f02_1001" value="3">
<input type="radio" name="f02_1001" value="4">
<input type="radio" name="f02_1001" value="5">
</td>
</tr>
<tr>
<td align="left"><input type="text" name="f03" size="20" maxlength="2000" value="9" style="display:none" id="f02_0009">
<input type="radio" name="f02_1001" value="1">
<input type="radio" name="f02_1001" value="2" checked>
<input type="radio" name="f02_1001" value="3">
<input type="radio" name="f02_1001" value="4">
<input type="radio" name="f02_1001" value="5">
</td>
</tr>
<tr>
<td align="left"><input type="text" name="f03" size="20" maxlength="2000" value="10" style="display:none" id="f02_0010">
<input type="radio" name="f02_1001" value="1">
<input type="radio" name="f02_1001" value="2" checked>
<input type="radio" name="f02 
I followed the steps that shown on the following website to retrieve more information about the 404 error:
http://www.inside-oracle-apex.com/oracle-apex-got-404-not-found-2/
The following is the result:
------------------------------------------------------------
Thu, 02 Jul 2009 08:59:03 GMT
wwv_flow.accept: SIGNATURE (parameter names) MISMATCH
VARIABLES IN FORM NOT IN PROCEDURE: F02_1001
NON-DEFAULT VARIABLES IN PROCEDURE NOT IN FORM:
DAD name: apex
PROCEDURE : wwv_flow.accept
URL : ................./pls/apex/wwv_flow.accept
PARAMETERS :
===========
P_FLOW_ID:
101
P_FLOW_STEP_ID:
2
P_INSTANCE:
2312756507258543
P_PAGE_SUBMISSION_ID:
4301522971016920
P_REQUEST:
T_BEHEER MEDEWERKERS
F03:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
F02_1001:
2
P_MD5_CHECKSUM:
------------------------
Can anybody please give me some tips or dose anybody knows the answer???? 
Hello:
As surmised by Scott, it is indeed the generated HTML that is the cause of the error. Specifically, it is the name specified for the radio-buttons that need to be changed. The given name of 'f02_1001' is invalid. Allowed names for user generated form elements are 'f01' through 'f50'.
Varad

Change language with item

Please,
I try to change the language with a text item. I have found code on the forum that I changed to this :
htp.p('<a class="MenuLienLanguage" href="http://172.16.16.18:7778/pls/orasso/orasso.wwctx_app_language.set_language?p_http_language=fr-fr&p_nls_language=f&p_nls_territory=FRANCE&p_requested_url=/pls/portal/url/page/' || pageName || '">Francais</a>') ;
The only problem I have is 'PageName' ? Is it possible to pass the name dynamical (with tag or procedure) ???
Thx in advance,
D. 
this link set language on sso level and you need set language on sso and midtire level as
procedure print_lang as
v_lang varchar2(10):=portal.wwctx_api.get_nls_language;
begin
htp.p('<script language="javascript">
<!-- Comment out script for old browsers
function redirect_language(lang,local,teritor){
var link=window.location.href;
document.pred.p_http_language.value=lang;
document.pred.p_nls_language.value=local;
document.pred.p_nls_territory.value=teritor;
document.pred.p_requested_url.value=link;
document.pred.submit();} //-->
</script>');
if v_lang='ru' then
htp.p('<table CELLPADDING="0" CELLSPACING="0" BORDER="0"><tr>
<td align="center" ><font class="PortletText1"><img src="/images/lang_ru.gif" border="0"><br><b>Russia</b></font></td>
<td valign="bottom"><font class="PortletText1">/</font></td>
<td align="center"><a class="PortletText1" HREF="javascript:redirect_language(''en'',''us'',''AMERICA'');"><img src="/images/lang_en.gif" border="0"><br>English</a></td>
</tr></table>');
else
htp.p('<table CELLPADDING="0" CELLSPACING="0" BORDER="0"><tr>
<td align="center"><a class="PortletText1" HREF="javascript:redirect_language(''ru-ru'',''ru'',''CIS'');"><img src="/images/lang_ru.gif" border="0"><br>Russia</a></td>
<td valign="bottom"><font class="PortletText1">/</font></td>
<td align="center"><font class="PortletText1"><img src="/images/lang_en.gif" border="0"><br><b>English</b></font></td>
</tr></table>');
end if;
htp.p('<form ACTION="/pls/portal/PORTAL.wwctx_app_language.set_language" METHOD="POST" name="pred">
<input TYPE="hidden" NAME="p_http_language" VALUE="">
<input TYPE="hidden" NAME="p_nls_language" VALUE="">
<input TYPE="hidden" NAME="p_nls_territory" VALUE="">
<input TYPE="hidden" NAME="p_requested_url" VALUE="">
</form>');
end;
may it helps 
Thx, it works fine

Categories

Resources