Re: Problems with PL/SQL Web Toolkit
From: Alex <alex.iava__NOSPAM___at_tiscali.it>
Date: Mon, 3 Nov 2003 12:38:01 +0100
Message-ID: <bo5emu$c3q$1_at_newsread.albacom.net>
Date: Mon, 3 Nov 2003 12:38:01 +0100
Message-ID: <bo5emu$c3q$1_at_newsread.albacom.net>
"Chris" <cs123._no_spam__at_telstra.com> wrote
in message news:%Vqpb.176918$bo1.90225_at_news-server.bigpond.net.au...
>
[cut]
[cut]
>
> Can you supply the code for the form and the procedure
>
The code of the first procedure ("Prova_form") is:
> Can you supply the code for the form and the procedure
>
The code of the first procedure ("Prova_form") is:
procedure PROVA_FORM
as
begin
htp.htmlopen;
htp.headopen;
htp.print('<script language="JavaScript">');
htp.print('function checkForm(f)');
htp.print(' {');
htp.print(' if ((f.nome.value == "") || (f.cognome.value == ""))');
htp.print(' {');
htp.print(' alert("Inserire il nome e il cognome")');
htp.print(' return false');
htp.print(' }');
htp.print(' else');
htp.print(' {');
htp.print(' return true');
htp.print(' }');
htp.print(' }');
htp.print('</script>');
htp.headclose;
htp.bodyopen(cattributes => 'bgcolor="#800000"');
htp.fontopen('#c0c0c0', cface => 'Verdana', csize => '4');
htp.formopen('web_pack.risultato', 'GET', cattributes => 'name="miaForm" onsubmit="return checkForm(this)"');
htp.bold('Indicare il nome: ');
htp.formtext('nome', '25', '20', null, 'style="color: #0000ff;"');
htp.br;
htp.bold('Indicare il cognome: ');
htp.formtext('cognome', '25', '20', null, 'style="color: #0000ff;"');
htp.br;
htp.formsubmit('btnSubmit', 'INVIA');
htp.formclose();
htp.fontclose;
htp.br;
st_tabella2;
htp.bodyclose;
htp.htmlclose;
end PROVA_FORM;
begin
htp.htmlopen;
htp.headopen;
htp.print('<script language="JavaScript">');
htp.print('function checkForm(f)');
htp.print(' {');
htp.print(' if ((f.nome.value == "") || (f.cognome.value == ""))');
htp.print(' {');
htp.print(' alert("Inserire il nome e il cognome")');
htp.print(' return false');
htp.print(' }');
htp.print(' else');
htp.print(' {');
htp.print(' return true');
htp.print(' }');
htp.print(' }');
htp.print('</script>');
htp.headclose;
htp.bodyopen(cattributes => 'bgcolor="#800000"');
htp.fontopen('#c0c0c0', cface => 'Verdana', csize => '4');
htp.formopen('web_pack.risultato', 'GET', cattributes => 'name="miaForm" onsubmit="return checkForm(this)"');
htp.bold('Indicare il nome: ');
htp.formtext('nome', '25', '20', null, 'style="color: #0000ff;"');
htp.br;
htp.bold('Indicare il cognome: ');
htp.formtext('cognome', '25', '20', null, 'style="color: #0000ff;"');
htp.br;
htp.formsubmit('btnSubmit', 'INVIA');
htp.formclose();
htp.fontclose;
htp.br;
st_tabella2;
htp.bodyclose;
htp.htmlclose;
end PROVA_FORM;
The code of the second proc ("risultato")
is:
procedure
RISULTATO(nome in varchar2 default null,
cognome in varchar2 default null) as
begin
htp.print(nome);
htp.print(cognome);
exception
when others then
htp.print('Errore');
end RISULTATO;
cognome in varchar2 default null) as
begin
htp.print(nome);
htp.print(cognome);
exception
when others then
htp.print('Errore');
end RISULTATO;
I modified the settings for the "Package/Session
State" in the DAD configuration and I selected "Stateless (Perserve Package
State)". With this last update, I have no errors if I call the second procedure
("risultato") with parameters in the URL (i.e.
web_pack.risultato?nome=aaaa&cognome=bbbb). But If I try to execute it as
result of the form I get the errors...
Could you please help me?
Thanks
Alex
Received on Mon Nov 03 2003 - 12:38:01 CET