problem with htp.formOpen(...)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: problem with htp.formOpen(...)

  1. #1
    Join Date
    Nov 2005
    Posts
    3

    problem with htp.formOpen(...)

    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).

  2. #2
    Join Date
    Nov 2005
    Posts
    3
    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 (-;

  3. #3
    Join Date
    Nov 2008
    Posts
    1
    I have same problem. Could you please explain more about how did you fix that.

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width