Home » Developer & Programmer » Forms » i need help with the websites
i need help with the websites [message #287212] Tue, 11 December 2007 07:30 Go to next message
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 #287215 is a reply to message #287212] Tue, 11 December 2007 07:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
For PL/SQL, have a look at:
Application Developer's Guide - Fundamentals
PL/SQL User's Guide and Reference

For Forms, I don't know.

Regards
Michel
Re: i need help with the websites [message #287270 is a reply to message #287212] Tue, 11 December 2007 14:59 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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 #287300 is a reply to message #287270] Tue, 11 December 2007 21:48 Go to previous messageGo to next message
cmerry
Messages: 109
Registered: November 2005
Location: Idaho
Senior Member
I have found that due to the convergence of technologies, beginners are often confused in this area. When you mentioned designing a form, are you referring to an Oracle Form (built with Forms Builder), a Portal Form, or an HTML form? In any case, OTN is a great place to start, but it will help to figure out what type of web application you are working with.
Re: i need help with the websites [message #287421 is a reply to message #287212] Wed, 12 December 2007 03:49 Go to previous messageGo to next message
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 Go to previous message
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/
Previous Topic: get old value when update on form
Next Topic: showing message on several lines
Goto Forum:
  


Current Time: Sun Dec 04 20:43:43 CST 2016

Total time taken to generate the page: 0.32663 seconds