Which parameters passed over
Date: 17 May 1999 10:04:20 GMT
Message-ID: <7hopj4$gj6$1_at_news.liv.ac.uk>
Hi,
How can I know which parameters will be passed from a from? For a FormSelect form, I believe there is only one parameter passed to a procedure, but it needs two parameters to make it run correctly, and the first parameter is empty, but without it, I just get the following error:
OWS-05111: No stored procedure matches this call with the
arguments passed
ORA-00000: normal, successful completion
PL/SQL Cartridge SERVICE: jas
PROCEDURE: web_reg.modify_menu
PARAMETERS:
HHH:
dddddddddddddddddddd
Why?
Thank you for any help.
Zhuang from England
The testing procedures is as follows:
CREATE OR REPLACE PACKAGE web_reg AS
PROCEDURE admin_choice;
-- PROCEDURE modify_menu (menu_name
www_infos.info_menu%TYPE);
PROCEDURE modify_menu (menu_name IN VARCHAR2
default NULL, abc VARCHAR2);
-- PROCEDURE modify_menu (menu_name IN VARCHAR2
default NULL);
END web_reg;
/
show error
create or replace PACKAGE BODY web_reg AS
PROCEDURE admin_choice
IS
-- i integer;
BEGIN
-- htp.p('Your choice is ==> ' || choice);
htp.formOpen('web_reg.modify_menu');
htp.formSelectOpen('HHH', NULL,3);
htp.formSelectOption('aaaaaaaaaaaaaaaaa');
htp.formSelectOption('bbbbbbbbbbbbbbbbb');
htp.formSelectOption('ccccccccccccccccc');
htp.formSelectOption('dddddddddddddddddddd');
htp.formSelectClose;
htp.br;
htp.formSubmit;
htp.formClose;
-- tail;
END admin_choice;
--
PROCEDURE modify_menu (menu_name VARCHAR2, abc varchar2)
-- PROCEDURE modify_menu (menu_name VARCHAR2)
IS
BEGIN
-- header('ssssssssssss');
htp.p('What is the menu_name ' || menu_name);
htp.br;
htp.p('What is the abc ' || abc);
END modify_menu;
END web_reg;
/
show error
Zhuang Li | Phone 0151-794-3741 M.I.S | Fax: 0151-794-3759 Computing Services, | __o __o __o Liverpool University | _ \<_ _ \<_ _ \<_ Liverpool, L69 7ZF, U.K. | (_)/(_) (_)/(_) (_)/(_)Received on Mon May 17 1999 - 12:04:20 CEST
------------------------------------------------------------