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@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]
>
> 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;

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;

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 - 05:38:01 CST