Tutorial: Oracle Form Builder

1. From the Class.Schedule.Fall2006.html web page, copy the script file for the Inventory Database.
2. Start SQL Plus. Go to:

   Start > Programs > Oracle > Application Development > SQL Plus

   [For 4th floor computer lab: Start > All Programs > Oracle > Oracle SQL Plus > SQL Plus]

3. When the login window appears, logon using your oracle account username, password, and connect string (info364).
4. At the SQL Plus prompt, paste the SQL syntax to create the Inventory Database.
5. At the SQL Plus prompt, type exit and hit return. This will close the SQL Plus window.
6. Start OC4J Instance. Go to:

   Start > Programs > Oracle > Developer Suite > Form Developer > Start OC4J Instance

   [For 4th floor computer lab: Start > All Programs > Oracle > Oracle Developer Suite > Forms Developer > Start OC4J Instance]

   ** Let this window run in the background. Do not close the window, just minimize it.

7. Start Form Builder. Go to:

   Start > Programs > Oracle > Developer Suite > Form Developer > Form Builder.

   [For 4th floor computer lab: Start > All Programs > Oracle > Oracle Developer Suite > Forms Developer > Form Builder]

8. Select : Tools > Data Block Wizard
9. In the next two window, click Next.
10. In the next window, make sure "Table or View" is selected. Click Next.
11. Click 'Browse'. Login.
12. Select Current User and Tables.
13. Select table COMPUTER. Click OK.
14. Click the Select All button (>>). Click Next.
15. In the next window, click Next.
16. Leave the default option "Create the Data Block and call the Layout Wizard."
17. Click Finish.
18. In the Welcome Screen, click Next.
19. Click Next again.
20. Select all available items from our Data Block.
21. Click Next.
22. Click Next again.
23. Select Form. Click Next.
24. Enter a title for the frame and Click Finish.
25. Press CTRL + S to save your form. Choose the directory location, c:\temp. Choose the name computer.fmb
26. Press CTRL + R to run your form.
27. If you see only HTML code in the browser, that means the content was blocked.
    1. Hit F5 to refresh the screen.
    2. Click OK on the Information Bar pop-up window.
    3. Right-click on the yellow strip and select the option 'Allow Blocked Content'.
    4. Click Yes on the Security Warning pop-up window.
    5. Click Yes on the Internet Explorer pop-up window.
28. You should be able to see the form you just created in the browser.
29. Select Execute from the Query menu. Use the navigation buttons to move between records or Insert Record button to insert a record.