| calling procedure in Forms6i [message #79793] |
Fri, 12 July 2002 13:52  |
Mark
Messages: 284
Registered: July 1998
|
Senior Member |
|
|
Hello, how can I call a procedure in Forms6i.
i.e fill in text boxes, and press button to execute procedure.
Should I assign the txt boxes to the procedure variables? Or should I put this in a trigger like WHEN-BUTTON-PRESSED..not quite sure how to go about it..
PROCEDURE create_account(
c_name_f VARCHAR2,c_name_l VARCHAR2, c_addr VARCHAR2,
c_city VARCHAR2, c_state VARCHAR2, c_zip VARCHAR2,
c_phone VARCHAR2, c_email VARCHAR2, c_case_num VARCHAR2,
c_case_date DATE, c_upload_date DATE, c_file_ref_upload VARCHAR2,
file_upload_clob CLOB)
IS
BEGIN
INSERT INTO registration VALUES
(reg_id_sequence.nextval,c_name_f,c_name_l,c_addr,c_city,c_state,c_zip,
c_phone,c_email);
INSERT INTO steno_table VALUES
(case_id_sequence.nextval,c_case_num, c_case_date, c_upload_date, c_file_ref_upload,
file_upload_clob, reg_id_sequence.currval);
END;
Thanks
|
|
|
|
| Re: calling procedure in Forms6i [message #79797 is a reply to message #79793] |
Fri, 12 July 2002 21:34  |
Balamurugan.R
Messages: 91
Registered: March 2001
|
Member |
|
|
Hi,
You can call the procedure any where in forms,
U have to decide when this procedure has to execute,
i.e whether it should execute after the fill in text box, or when press the any button. simply call the
procedure with procedure name , for ex account(:block1.text_item1,:block1.text_item5,:block3.text_item2) like this.
Hope this would help U.
With luv,
Balu
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
