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

http://download-west.oracle.com/docs/cd/B12166_01/web/B10469_01/plsqlcon.htm

• 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

http://forums.oracle.com/forums/message.jspa?messageID=590264#590264

• Generic LOV - Francois Degrelle, French author from ITToolbox

http://www.oracle.com/technology/products/forms/pdf/10g/community_paper_generic_lov.pdf

• Customised colours - Francois Degrelle, French author from ITToolbox

http://www.oracle.com/technology/products/forms/pdf/10g/community_paper_colors.pdf

• 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

• Keyfilter

http://www.oracle.com/technology/sample_code/products/forms/distributions/keyfilter.zip

• Displaying Images

"Displaying Image in Forms 6i from BLOB Database field " http://www.orafaq.com/forum/t/51889/67467/

• Playing and storing sounds

http://www.orafaq.com/forum/t/51812/67467/

• How to convert .FMB file .EXE for distribution

http://forums.oracle.com/forums/thread.jspa?threadID=327166&tstart=0

• 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

http://www.prenhall.com/divisions/bp/app/hoffer/oracle/tutorial/

• 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

• Calendar OCX http://www.orafaq.com/forum/m/128247/43055/?srch=calendar+control#msg_127916

• 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/

• tnsnames.ora

http://www.databasejournal.com/features/oracle/article.php/3092461

• http://groups.google.com/group/mailing.database.myodbc/browse_frm/thread/e4dd5085ab9e4e82/87608f73f3dba6dc?hl=en&lr=&ie=UTF-8&safe=off&rnum=1&prev=/groups%3Fq%3DMySQL%2Bpivoting%2Btable%2Bsgreen%26ie%3DUTF-8%26hl%3Den#87608f73f3dba6dc

• PJCs and Java Beans library

http://forms.pjc.bean.over-blog.com/

• Forms and PL/SQL articles

http://sheikyerbouti.developpez.com/index_en/