Home » Developer & Programmer » Forms » i need help with the websites
| i need help with the websites [message #287212] |
Tue, 11 December 2007 07:30  |
rebeccah@falcorp.co.za
Messages: 26
Registered: October 2007
Location: midrand
|
Junior Member |
|
|
hi all
i need to develop a online system (to register a new employee record salary update, contract information, etc) and deploy it on portal
i need to use plsql to develop this system.
can you please point me to the right websites as to where to start or if you have notes for me to down load
I dont know how to even design a form in plqsl(uning toad 7.6)
thanks in advance
rebeccah
|
|
|
|
|
|
| Re: i need help with the websites [message #287270 is a reply to message #287212] |
Tue, 11 December 2007 14:59  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Forms are created by Forms Builder. You can NOT do that using TOAD; simply, it is a wrong tool. Furthermore, PL/SQL doesn't fit in here either. PL/SQL knowledge may help (you'll probably want to create form triggers, procedures etc.), but you can not create a form using PL/SQL; there's no 'CREATE FORM form_name AS ...' command.
Download Developer Suite from the Oracle Technology Network (OTN) download page. Documentation can be found at the same place, only a different section. OTN also offers sample code; download sample forms and "debug" them.
P.S. I forgot to mention: there's also Oracle Application Express. It is a rapid web application development tool for the Oracle database. Using only a web browser and limited programming experience, you can develop and deploy professional-looking applications that are both fast and secure. Perhaps you'll rather use this product instead of Forms.
[Updated on: Tue, 11 December 2007 15:02] Report message to a moderator |
|
|
|
|
|
| Re: i need help with the websites [message #287421 is a reply to message #287212] |
Wed, 12 December 2007 03:49 |
rebeccah@falcorp.co.za
Messages: 26
Registered: October 2007
Location: midrand
|
Junior Member |
|
|
hi all
for example let's say this is my welcome page in my system
<form action="mailto:rebeccah@FALCORP.CO.ZA" method="post">
Your Name<input type="text" name="name" /><br>
Your Email<input type="text" name="email" /><br>
<textarea name="comments" rows="5" columns="150">What's on your mind?</textarea><br>
<input type="submit" value="Shout it!">
</form>
an it has some other links like when i click/follow a button lets sa registering a new employee, the data is saved in the database and after been validaded and all that,
my question is how do i create / converc the form to plsql
1. in order to deploy my system to a server and acces through url
2. create packages/procedure/trigger to manipulate calulation and calling of other form etc
as i said i do not now where to start , i can use html to create the front_end(GUI)
what about the back end- database and calulation etc
I have a system that is not functioning effectively to use as an example but there are many thing that i do not understand
here is one of the packages from that system
CREATE OR REPLACE package BEE.frma11b as
/*************************************************/
/*** Standard programs for webpage display *******/
/*************************************************/
-- define the components of the form.
procedure define_WebPage;
-- define / update (based on user action)the component.
procedure update_Components;
-- respond to user action.
procedure implement_Action;
/*************************************************/
/*************************************************/
/*************************************************/
end;
/
CREATE OR REPLACE package body BEE.frma11b as
gModule constant varchar2(10):='FRMA11B';
/******************************************************************************/
/******************************************************************************/
procedure define_Webpage is
begin
web.gWebPage.page_title:=mainmenu.get_page_title(gModule);
web.gWebPage.debug_status:='OFF';
web.gWebPage.form_name:=gModule;
web.gWebPage.proc_name:='bee.'||gModule;
web.gWebPage.jscript_graphics:='N';
web.gWebPage.application:=mainmenu.Application_Name;
web.gWebPage.registered:='Y';
end;
/******************************************************************************/
/******************************************************************************/
procedure update_Components is
c web.TComponent;
begin
tools.ctext (10, 60, 200,140, 'Shareholder Group','BTXT1',web.fnvl('BTXT1',''));
tools.ctext (10, 85 ,200,140, 'Measured Enterprise Value','BTXT1',web.fnvl('BTXT1',''));
tools.ctext (10, 110,200,140, 'Associate Enterprise Value','BTXT1',web.fnvl('BTXT1',''));
tools.ctext (370,60, 280,130, 'Name','BTXT1',web.fnvl('BTXT1',''));
tools.ctext (370,85, 100,130, 'Adjustment Factor','BTXT1',web.fnvl('BTXT1',''));
tools.ctext (10, 140,80,90, 'Claim Start Date','BTXT1',web.fnvl('BTXT1','DD/MM/YYYY'));
tools.ctext (200,140,80,90, 'Claim End Date','BTXT1',web.fnvl('BTXT1','DD/MM/YYYY'));
tools.ctext (400,240,100,130, 'Black Voting Rights %','BTXT1',web.fnvl('BTXT1',''));
tools.ctext (400,265,100,130, 'Black Economic Interest %','BTXT1',web.fnvl('BTXT1',''));
tools.ctext (400,290,100,130, 'Net Equity Interest','BTXT1',web.fnvl('BTXT1',''));
tools.cbutton(400,200,230,'Calculate Adjustment Factor','BTNCALC','CALCULATE');
mainmenu.menu_button(1,'HOME','GOTO_MAINMENU');
mainmenu.menu_button(2,'BACK','GOTO_FRMA11A');
mainmenu.menu_button(7,'SAVE','SAVE');
mainmenu.menu_components;
end;
/******************************************************************************/
/******************************************************************************/
procedure display_reload is
begin
-- show default banner/menu.
mainmenu.menu_show;
-- main area.
mainmenu.open_form_area(gModule );
-- form specific components.
web.show('TOOLS');
web.show('BTXT1');
web.show('BTXT2');
web.show('BTXT3');
web.show('BTNCALC');
tools.hlabel(10,25,'Transaction: Stat 101 - Asset Disposal');
web.show('MAGICBTN1');
web.show('MAGICBTN2');
web.show('MAGICBTN7');
mainmenu.close_form_area;
end;
/******************************************************************************/
/******************************************************************************/
procedure implement_Action is
begin
--web.display_form_data;
if web.getFormVar('#action')='RELOAD' then
display_reload;
else
display_reload;
end if;
end;
/******************************************************************************/
/******************************************************************************/
begin
web.gComponents.delete;
web.gTabCanvas.delete;
web.sDefault:=mainmenu.cssDefault;
end;
/
if any body can point me in the right directions i'd be grateful
rebeccah
|
|
|
|
| Re: i need help with the websites [message #287536 is a reply to message #287421] |
Wed, 12 December 2007 09:39 |
 |
cmerry
Messages: 109
Registered: November 2005
Location: Idaho
|
Senior Member |
|
|
Ah, an HTML form. This simply requires calling htp.p with your HTML embedded as a character string. For example:
CREATE OR REPLACE PACKAGE package_name IS
PROCEDURE proc_name IS
BEGIN
htp.p('
<form action="mailto:rebeccah@FALCORP.CO.ZA" method="post">
Your Name<input type="text" name="name" /><br>
Your Email<input type="text" name="email" /><br>
<textarea name="comments" rows="5" columns="150">
What's on your mind?</textarea><br>
<input type="submit" value="Shout it!">
</form>
');
END;
END;
The URL for this page will depend upon the application server configuration. It will be something like http://domain:port/virtual_path/package_name.proc_name
Just google something like "Oracle Application Server example". You'll find plenty of examples such as http://www.geocities.com/siliconvalley/peaks/9111/
|
|
|
|
Goto Forum:
Current Time: Mon Feb 03 00:49:28 CST 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
