Commonly Asked FORMS Questions (FAQ is elsewhere)

From Oracle FAQ
Jump to: navigation, search

Some pointers to comonly asked FORMS questions:

  • 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

  • B10802 = PL/SQL Packages and Types Reference 10g Release 1 (10.1)
  • 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

  • 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

  • tnsnames.ora

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

  • PJCs and Java Beans library

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

  • Forms and PL/SQL articles

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