Commonly Asked FORMS Questions (FAQ is elsewhere)
Some pointers to comonly asked FORMS questions:
- Forms FAQ - this site
- Go to http://www.oracle.com/technology/documentation/forms.html. Find 'Guidelines for Building Applications'. Download it and search for 'ora_ffi'.
- Go to http://www.oracle.com/technology/documentation/forms.html. Find 'Form Builder Reference'. Download it and search for 'run_report'.
- Go to http://www.oracle.com/technology/documentation/forms.html. Find 'Guidelines for Building Applications' and 'Form Builder Reference'. Download them for future reference, and use the 'search' facility of Adobe Reader to access the bits and pieces you need.
- Go to http://otn.oracle.com/pls/db92/db92.homepage. There is a SQL, PL/SQL, and SQL*Plus link that should lead you to your answers.
- Go to http://www.oracle.com/technology/documentation/index.html. Press 'Search', enter 'dbms_sql', select the 10.1 documentation suite (first hot link), go down to 'PL/SQL Packages and Types Reference' and there are 53 references.
- Go to http://www.oracle.com/technology/products/forms/index.html and look for the 'Sample Code' under 'Resources'.
- Go to http://www.oracle.com/technology/products/forms/techlisting9i.html#overview and look for 'New Features'.
- From the Advanced Search page use the Google engine against Orafaq with a search term of '306500'.
- Interview questions - forms
http://www.orafaq.com/forum/m/116935/67467/?srch=array#msg_116935 Interview questions - dba - Keywords: interview DBA fullresponse daytoday http://www.orafaq.com/forum/mv/msg/53071/141465/67467/#msg_141465
- 10g migration link
- Go to http://www.oracle.com/technology/products/forms/htdocs/webutil/webutil.htm for full coverage of webutil.
- B10802 = PL/SQL Packages and Types Reference 10g Release 1 (10.1)
- Oracle 8i Documentation http://download-west.oracle.com/docs/cd/A87860_01/doc/index.htm
- Populate block using cursor
http://www.orafaq.com/forum/m/605/67467/?srch=populate+block+cursor+create_record#msg_605 and my feelings about it. http://www.orafaq.com/forum/m/134237/67467/?srch=populate+block+cursor+create_record#msg_134237
- Selecting Multiple Values from LOV
- Generic LOV - Francois Degrelle, French author from ITToolbox
- Customised colours - Francois Degrelle, French author from ITToolbox
- Simple animation sample form
http://www.orafaq.com/forum/t/49957/67467/ anim.fmb works in 6.0 on our machine
- Progress Bar
Search this forum for 'progress' and you will find http://www.orafaq.com/forum/m/126649/67467/?srch=progress#msg_126649 and http://www.orafaq.com/forum/m/120834/67467/?srch=progress#msg_120834.
- Installing 9i and 10g
Installation Cookbooks: Deploying Forms on the Web http://databasejournal.com/features/oracle/article.php/3405951 Installation Cookbooks: Deploying Reports on the Web http://databasejournal.com/features/oracle/article.php/3408861 Installation Cookbook: Installing Oracle Application Server 10g (9.0.4)Forms and Reports Services http://www.databasejournal.com/features/oracle/article.php/3322591
- Displaying Images
"Displaying Image in Forms 6i from BLOB Database field " http://www.orafaq.com/forum/t/51889/67467/
- Playing and storing sounds
- How to convert .FMB file .EXE for distribution
- Font problems and keyboard mappings - Oracle? Forms Developer and Oracle Forms Services 6i (Patch 7)
http://www.oracle.com/technology/documentation/forms/6idocs/a92103_01.pdf Keywords: keybinder.java, frmweb.res, frmpcweb.res
- Loading data into a block MANUALLY
http://www.orafaq.com/forum/m/111031/67693/#msg_111031 MANUAL previous and next master key record retrieval http://www.orafaq.com/forum/m/111031/67693/#msg_111031 Sample MANUAL get employees form http://www.orafaq.com/forum/t/52330/67467/
- Tutorial for Designer/2000, by Saonee Sarker
- Run report - with parameters - good example for 6i
http://www.lv2000.com/articles/runreport.htm also http://www.orafaq.com/forum/t/52330/67693/ also the code from Bathurst E:\Lands - AusPost\Report_launch.sql Oracle - 9i Reports in Forms White Paper http://www.oracle.com/technology/products/forms/pdf/277282.pdf From http://www.orcl-toolbox.com/fapimasterscripts.asp FormsAPI there is 'conv_runprod_runrepobj' see: H:\work\scratch\conv_runprod_runrepobj.zip
- XP SP2 problem - set USE_SHARED_SOCKET=TRUE in registry and reboot. http://www.orafaq.com/forum/t/52166/67467/
- win_api_dialog.select_printer problem in 10G
https://metalink.oracle.com/metalink/plsql/f?p=200:27:8311904113866285087::::p27_id,p27_show_header,p27_show_help:639358.999,1,1 refers to https://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=300844.1
- Sending emails - a newer one http://www.orafaq.com/forum/t/57136/67467/
- PJCs and Java Beans library
- Forms and PL/SQL articles