problem with htp.formOpen(...)

[pyrocks]

Hello all,

I'm having a problem with htp.formOpen(...) in the following code:


CREATE OR REPLACE PACKAGE BODY insert_into AS
.
.
.
PROCEDURE insert_country(name IN VARCHAR2 DEFAULT NULL) IS
BEGIN
header;
htp.print(name);
footer;
END insert_country;



PROCEDURE country IS
BEGIN
header;
htp.header(1,'Insert data into the "Country" table');
htp.formOpen('insert_into.insert_country');
htp.print('Enter a Country');
htp.formText('country_data');
htp.formSubmit(cvalue=>'Execute');
htp.formClose;
htp.br;
footer;
END country;
.
.
.
END insert_into;

I use this code inside a package named 'insert_into'. I load the procedure 'insert_into.country' with my browser and I see the form. By pressing the "Execute" button, it should submit the form and call the "insert_into.insert_country" procedure just to show nothing (a test).
BUT, whenever I press the "Execute" button instead of seeing the generated page from 'insert_into.insert_country' I get the infamous 404 error - page not found. Once I press 'refresh' in my browser on the same page I get 404 I suddenly see the page generated by insert_into.insert_country.

any ideas why I get 404 while the procedure exists and is viewable in the browser?

P.S
Both mentioned procedures are mentioned in the package specification (thus I can see them in my browser).

[pyrocks]

There was a type mismatch in the Parameters that 'insert_country' recieved - managed to Fix it , so just ignore this thread ^^

thanks for reviewing anyway (-;

[Ramtin]

I have same problem. Could you please explain more about how did you fix that.

Thanks