PK c\Eoa,mimetypeapplication/epub+zipPKc\EiTunesMetadata.plista artistName Oracle Corporation book-info cover-image-hash 479315746 cover-image-path OEBPS/dcommon/oracle-logo.jpg package-file-hash 235546265 publisher-unique-id E10394-02 unique-id 675006285 genre Oracle Documentation itemName Oracle® Forms Upgrading Oracle Forms 6i to Oracle Forms 11g, 11g Release 1 (11.1.1) releaseDate 2009-10-12T21:38:30Z year 2009 PK faPKc\EMETA-INF/container.xml PKYuPKc\EOEBPS/whymigr.htm:6 Why Upgrade?

1 Why Upgrade?

This chapter contains the following sections:

1.1 Overview

Oracle Forms Builder and Oracle Forms Services have been upgraded to simplify the development and deployment of Forms applications on the Web. A number of features have been added. In restructuring the Oracle Forms product, some legacy features have been dropped or scaled back. The future of Forms includes improving the Java-based Web user interface and extending product "openness" by allowing Java integration on all three tiers.

1.2 About Upgrading Your Forms Applications to 11g (11.1.1)

To upgrade your Oracle Forms applications, open your Forms 6i source files (FMB, MMB, PLL, and so on) in the Oracle Forms 11g (11.1.1) Builder, save them, then compile them. You can also use the Oracle Forms Compiler to upgrade your Forms 6i applications.

You can use the Forms Migration Assistant to perform batch upgrades. For more information, see Chapter 2, "Using the Oracle Forms Migration Assistant".


Note:

You must compile rp2rro.pll into rp2rro.plx if your Form depends on this library. rp2rro.pll can be found in ORACLE_HOME/forms/rp2rro.pll. The resulting plx should be in your FORMS_PATH.

1.3 Forms 10g Features Removed from Oracle Forms

The following features have been dropped from Oracle Forms 10g and later:

1.4 Forms 6i Features Removed from Oracle Forms

The following features have been dropped from Oracle Forms 9.0.2 and later:

In addition, rules enforcing trigger usage have become stricter.

1.5 Components of 6i Developer Product Suite Removed

The following components have been removed.

Table 1-1 Components Removed from the Developer Suite

Obsolete ComponentUpgrade Notes

Oracle Graphics

If your applications use the Graphics Web Cartridge or Oracle Graphics Runtime, you should rewrite your applications and redevelop the graphics using other means such as Java, Bi Beans. For more information, see the demos at http://www.oracle.com/technology/sample_code/products/forms/index.html.

Oracle Forms Listener and Load Balancing Components

Use the Forms Listener Servlet to manage Forms sessions on the Web. The Forms Listener Servlet provides:

  • Improved security because all traffic is directed through standard Web server HTTP or HTTPS ports, with no extra ports open through the firewall.

  • Compliance with standards that can be used for load balancing techniques.

  • Broader firewall and proxy support.

  • Less administration because the listener and load balancing processes do not need to be managed.

  • Simplified HTTPS support because a separate Web server SSL certificate for the Forms listener is not required.

Oracle Forms Server Cartridge and CGI

Use the Forms Servlet. The functionality available with the Oracle Forms Server cartridge and CGI was incorporated into the Forms Servlet, which was first available in Oracle Forms Release 6i patchset 2.

Oracle Procedure Builder

Use the facilities for editing and debugging local and server-side PL/SQL code in Forms Developer, which has been considerably improved for this release.

Oracle Project Builder

No upgrade path or replacement functionality.

Oracle Translation Builder

Use TranslationHub to translate resource strings in Forms modules to deploy the modules in multiple languages.

Oracle Query Builder/Schema Builder

No upgrade path or replacement functionality.

Oracle Terminal

The resource files used by Web-deployed forms are text based and can be edited using a conventional text editor. As a result, Oracle Terminal is no longer required for the product.

Open Client Adapters (OCA)

In order to provide platform-independent access to a wider range of non-Oracle data sources, use the Oracle Transparent Gateway and Generic Connectivity solutions instead of OCA.

Tuxedo Integration

No upgrade path or replacement functionality.

Performance Event Collection Services (PECS)

No upgrade path. Use Forms Trace and Oracle Trace, which are documented in the book Oracle Fusion Middleware Forms Services Deployment Guide (Part No. E10240-02).


1.6 How are Obsolete Item Types Handled when Upgrading Forms 6i Applications?

When you open a Forms application, obsolete item types are listed after the item-type poplist in the Property Palette. The property values for obsolete items are indicated as obsolete. For example, the property value for VBX would be "VBX Control (Obsolete)".


Note:

If you are upgrading from pre-6i you must upgrade to 10g and then to 11g. If you are upgrading from 6i or later, you can go directly to 11g. See Chapter 16, "Upgrading from Pre-Forms 6i Applications to Oracle Forms" for more information.

You can use the Oracle Forms Migration Assistant, described in Chapter 2, "Using the Oracle Forms Migration Assistant", to resolve many upgrade issues.

1.7 Are Tools Available to Assist with the Migration of Obsolete Features?

The Oracle Forms Migration Assistant is provided with Oracle Forms to help you upgrade your Forms 6i applications. See Chapter 2, "Using the Oracle Forms Migration Assistant" for details.

PKP?6:6PKc\EOEBPS/dcommon/oracle.gifJGIF87aiyDT2F'G;Q_oKTC[ 3-Bq{ttsoGc4I)GvmLZ).1)!ꑈ53=Z]'yuLG*)g^!8C?-6(29K"Ĩ0Яl;U+K9^u2,@@ (\Ȱ Ë $P`lj 8x I$4H *(@͉0dа8tA  DсSP v"TUH PhP"Y1bxDǕ̧_=$I /& .)+ 60D)bB~=0#'& *D+l1MG CL1&+D`.1qVG ( "D2QL,p.;u. |r$p+5qBNl<TzB"\9e0u )@D,¹ 2@C~KU 'L6a9 /;<`P!D#Tal6XTYhn[p]݅ 7}B a&AƮe{EɲƮiEp#G}D#xTIzGFǂEc^q}) Y# (tۮNeGL*@/%UB:&k0{ &SdDnBQ^("@q #` @1B4i@ aNȅ@[\B >e007V[N(vpyFe Gb/&|aHZj@""~ӎ)t ? $ EQ.սJ$C,l]A `8A o B C?8cyA @Nz|`:`~7-G|yQ AqA6OzPbZ`>~#8=./edGA2nrBYR@ W h'j4p'!k 00 MT RNF6̙ m` (7%ꑀ;PKl-OJPKc\EOEBPS/dcommon/oracle-logo.jpgw JFIFC    $.' ",#(7),01444'9=82<.342C  2!!22222222222222222222222222222222222222222222222222'7" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( (QEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQE!KEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEzE7V%ȣOΏ9??:a"\fSrğjAsKJ:nOzO=}E1-I)3(QEQEQEQEQEQEQE֝Hza<["2"pO#f8M[RL(,?g93QSZ uy"lx4h`O!LŏʨXZvq& c՚]+: ǵ@+J]tQ]~[[eϸ (]6A&>ܫ~+כzmZ^(<57KsHf妬Ϧmnẁ&F!:-`b\/(tF*Bֳ ~V{WxxfCnMvF=;5_,6%S>}cQQjsOO5=)Ot [W9 /{^tyNg#ЄGsֿ1-4ooTZ?K Gc+oyڙoNuh^iSo5{\ܹ3Yos}$.nQ-~n,-zr~-|K4R"8a{]^;I<ȤL5"EԤP7_j>OoK;*U.at*K[fym3ii^#wcC'IIkIp$󿉵|CtĈpW¹l{9>⪦׺*ͯj.LfGߍԁw] |WW18>w.ӯ! VӃ :#1~ +މ=;5c__b@W@ +^]ևՃ7 n&g2I8Lw7uҭ$"&"b eZ":8)D'%{}5{; w]iu;_dLʳ4R-,2H6>½HLKܹR ~foZKZ࿷1[oZ7׫Z7R¢?«'y?A}C_iG5s_~^ J5?œ tp]X/c'r%eܺA|4ծ-Ե+ْe1M38Ǯ `|Kյ OVڅu;"d56, X5kYR<̭CiطXԮ];Oy)OcWj֩}=܅s۸QZ*<~%뺃ȶp f~Bðzb\ݳzW*y{=[ C/Ak oXCkt_s}{'y?AmCjޓ{ WRV7r. g~Q"7&͹+c<=,dJ1V߁=T)TR՜*N4 ^Bڥ%B+=@fE5ka}ędܤFH^i1k\Sgdk> ֤aOM\_\T)8靠㡮3ģR: jj,pk/K!t,=ϯZ6(((((((49 xn_kLk&f9sK`zx{{y8H 8b4>ÇНE|7v(z/]k7IxM}8!ycZRQ pKVr(RPEr?^}'ðh{x+ՀLW154cK@Ng C)rr9+c:׹b Жf*s^ fKS7^} *{zq_@8# pF~ [VPe(nw0MW=3#kȵz晨cy PpG#W:%drMh]3HH<\]ԁ|_W HHҡb}P>k {ZErxMX@8C&qskLۙOnO^sCk7ql2XCw5VG.S~H8=(s1~cV5z %v|U2QF=NoW]ո?<`~׮}=ӬfԵ,=;"~Iy7K#g{ñJ?5$y` zz@-~m7mG宝Gٱ>G&K#]؃y1$$t>wqjstX.b̐{Wej)Dxfc:8)=$y|L`xV8ߙ~E)HkwW$J0uʟk>6Sgp~;4֌W+חc"=|ř9bc5> *rg {~cj1rnI#G|8v4wĿhFb><^ pJLm[Dl1;Vx5IZ:1*p)إ1ZbAK(1ׅ|S&5{^ KG^5r>;X׻K^? s fk^8O/"J)3K]N)iL?5!ƾq:G_=X- i,vi2N3 |03Qas ! 7}kZU781M,->e;@Qz T(GK(ah(((((((Y[×j2F}o־oYYq $+]%$ v^rϭ`nax,ZEuWSܽ,g%~"MrsrY~Ҿ"Fت;8{ѰxYEfP^;WPwqbB:c?zp<7;SBfZ)dϛ; 7s^>}⍱x?Bix^#hf,*P9S{w[]GF?1Z_nG~]kk)9Sc5Ո<<6J-ϛ}xUi>ux#ţc'{ᛲq?Oo?x&mѱ'#^t)ϲbb0 F«kIVmVsv@}kҡ!ˍUTtxO̧]ORb|2yԵk܊{sPIc_?ħ:Ig)=Z~' "\M2VSSMyLsl⺿U~"C7\hz_ Rs$~? TAi<lO*>U}+'f>7_K N s8g1^CeКÿE ;{+Y\ O5|Y{/o+ LVcO;7Zx-Ek&dpzbӱ+TaB0gNy׭ 3^c T\$⫫?F33?t._Q~Nln:U/Ceb1-im WʸQM+VpafR3d׫é|Aү-q*I P7:y&]hX^Fbtpܩ?|Wu󭏤ʫxJ3ߴm"(uqA}j.+?S wV ~ [B&<^U?rϜ_OH\'.;|.%pw/ZZG'1j(#0UT` Wzw}>_*9m>󑓀F?EL3"zpubzΕ$+0܉&3zڶ+jyr1QE ( ( ( ( ( ( ( (UIdC0EZm+]Y6^![ ԯsmܶ捆?+me+ZE29)B[;я*wGxsK7;5w)}gH~.Ɣx?X\ߚ}A@tQ(:ͧ|Iq(CT?v[sKG+*רqҍck <#Ljα5݈`8cXP6T5i.K!xX*p&ќZǓϘ7 *oƽ:wlຈ:Q5yIEA/2*2jAҐe}k%K$N9R2?7ýKMV!{W9\PA+c4w` Wx=Ze\X{}yXI Ү!aOÎ{]Qx)#D@9E:*NJ}b|Z>_k7:d$z >&Vv󃏽WlR:RqJfGإd9Tm(ҝEtO}1O[xxEYt8,3v bFF )ǙrPNE8=O#V*Cc𹾾&l&cmCh<.P{ʦ&ۣY+Gxs~k5$> ӥPquŽўZt~Tl>Q.g> %k#ú:Kn'&{[yWQGqF}AЅ׮/}<;VYZa$wQg!$;_ $NKS}“_{MY|w7G!"\JtRy+贾d|o/;5jz_6fHwk<ѰJ#]kAȎ J =YNu%dxRwwbEQEQEQEQEQEQEQEQEQE'fLQZ(1F)hQ@X1KEQE-Q@ 1KE3h=iPb(((1GjZ(-ʹRPbR@ 1KE7`bڒyS0(-&)P+ ڎԴP11F)h&:LRmQ@Q@Š(((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((?l:ϊw "{{-3j3%{+Zoi.{YUڪ1kcRմn5MBp%8'ƀ.QT[MmK-/W(Z̲lTq(Եm7F[SP"u2ĥNbp DZ V^]F[}S[lgd]$LW$d &êC˨Z&2oѦQ+rS Y3h$#`pÃ(tH5_dkt$n8g{Znn^i}FeC`q@(9i[[m,i۵ƗZ_@QeP#8 Qgiսis=칎pTH>C²訫~#>'5_?iOICjSq}vU95m6R.]B5 |V2]yS9#n@}*%Jw}fvۜآjnnic8EeK` c@(KͥͪE鯧%[1#q>p̼zքuoż9#`FApA$.NHvo A 0[,p W:3!X׵BGgHʼn\Ic/+ 2X<pP.BUs(zepZZǍO $< Tyiv6gzvv Ү`GlNO@QU9//വA.H,x$ƀ,U;[M-mu KiesL6@r,otfoMPGkt\3+/CcaSm(/:5ޛc; u"b# 1g^S Y3h$#`pÃ*QEQEQEQEQEQEQEQEQExY/WtcPKZ)< `uQW?!Bf(%O`oLֵ{u [y/-`  {v򿇞T~4ǟdKCp8I*C rwLOۭ%vٽ Fq"玴Doo-4CGh뼖am dmpSHiOb4c2ľ+ $A5(uzn, J3h7\-|MWP.!F<""Ghvp81q?> wI[yvo"N3&: ocӒOϫjb[˩e oTWv k_^ѡ]銓I9pFpx&?t>T h_|LVyA# ; l9#q8υ?<5)Vzz]ȩ#(v/*̊J&09qyVOs<|0}^XozGI|-.ps>'_bۿn睴~O4 ;<qeu%^$r2h$8<2nUh-GT.Mݺ p2y5ݟ|9iI<< r@~(Ӿ io-χHʲi3ʥ7%8#*rqπwڥU:7o LU0ޣ1zx|Y`Z <}@ѵO(sCQ[6N D gmkmU 7b >{W%{EWEѕYcT<% mo/CK=:yr3F #]Oewk=RM@O"9sP6x;'bx}k+vۜg z/^q66FVeYʘAMy_x?yi:F )#m`19w*a<W0n aUP`WCd) 2ZHUXNBƇ#96 >3xM_˳{m~*G 8wMČl'?:[c‚M"OY@BYn1R0rg/$:DC⇆l|aaZjep)VwePp:q5> !пJ$(/NskOq]V)pȆC`NrcxS4r{T ;4*s C²訪5_ Z ėcXf>Q,||O쿳h<eC3On+C஽oosF>fq21 6 A$(ksK{ai;w=r+F1+CiQ>]1^б :wś ,gt>RBȀn< ܺ[?E֠q5L:e?ļjP5 >Id6̞R ,q!J'?s_ë$yi;WX$?O5 ?6IaY?TT| ;£FP oz ԖLTH(N̠&00s5_|LVyA# ; l9#q3C'C?IWPo5og K£$yQW'? Z|ef]}GTC+![f<sqyVOe/[>;Ib{{R)T`7$FJ*?x0 xb}&o$7FigFvX Rpv0W?<RחmK* NP崙^8$ )87xI熿k: %^\-@A|Α !p1_A^^eLv2Ou.v*J>82@X =ҼWybfPJ7;YGbGzܱB;|Q$o V$rC=zW/s\?<4Ǖ&2(J3(,xyfh.%i4I;IyS^ӵG>i}܁!ov3A b($HB(0xI熿k9G’"VMފRNUnUv)$b$/ws8m~w}ۦ"Hd17c ;N8#_c|Y/&R| NV x';'~wC/šaG@vxOr@ |Q}⟇ͩI$vWf>(VV<v^rNܓ\?tV]G~!|;}MaC2 ټX IaY?TU^Uk\bƟ{,%Rp؏s0$*ApwM|7V7q#u#o(rq`W?J o]@Z[ۉgY٤s&Hqd\( *mu69&Kķ74C+(sqv /a7zZ\Mii݄S=4F69Y{ u6Vvrc=I| 99 ^?ihAw{ft@aN w (((((((((<-kڎZ\uSNp/\(x^.ιAw$x 6Z9BoN'8tP?k>a-$!I!]KmAۜdg$:; rv&T^<8 cV=DžkZx{=F.<miwVV?-xGNC%<ד.@=~UEc75?(SxPяW5-'MmT/WBl3jcSc/Q%ΤU{qoop8*(XYvrYAwk&7 |>tep$Ԑsʳ؂z "@TP0%1Ѷ_|y%$|dA,F :v]e擦}IWh[ S#zUcagYgaiy rI8Q$5Kγ5|yE랕E? </=$$YlrǓ]x;ÞE]Gpf;Nܽadm 07Wk7 ouBm+!Pdq^mA妙O]C}.]g,ǀ@zPy|gm|mrdY_kY Avg:_|mcjrXi;"$D_~A!YE7'`>>>(GPWvɻ9WzƓ:5ZϨ%ku,c p8-}x~6NMnWѵKDy.-4Fvd[9f3~,u4ܤȧ *p3q_W~]ϛyX"sW?O5 `ύu/VTചyoRݖ)Gl9Aֻ;v<ǧ{Y3gv{] xo>#,/uY.wI匡܌ FF=(|E]R}7l^ny bkB\(\`G?c͎kq%…V&4VW Eyx{K0 "؆$*BMwֽ<ęvg[\"%bP1k'[k2m(ht@!Ag'5cNC}R|zcw~~ǰPxǿHR{L,q$ X`O ռW4x䍃+s# |G ~dk0ƦD_<$(d-ig(G8 gX.lbiybw Kd7qax _jı$Vd$ h9d$;H?:l7? iw Oeqko#FIRm"2GŸrnS'Oeq#}S3jv"0.r399'.E+38fK¸ӂVcvfml$NI'I'$}4|?sO[fInfPebHڻysY ƺrVo21I!f%X~*H.x:o4iMR8`@g!Ny;ln->4PhwT:|ßOLQc<*9Us'PG%[ӊH +{x$qơU 8y$P** 7z4^=Kp NmU޵PO4 \xn⸷9$l]H #=oDӼGϤhoMX0H# |߄|GiX^]ZؓC@{7߯hum`,^;2$,kpEbGJ WUOS7+Q'$j|+xZd.xA;\a;FpFqyK]V5`B>AEn:GON(o5 |Y٭kjeDF֑Ahaԫp1^Ul,8- ;!1.I' 8$ƬPCŝ31ZI&[R䳰aNՈnq>k_t/ཱུl vêʜEX䳿LoxĈ  WwO mA”L8.䞾P?,{}[Գi"Zb_!Klt M'=%րhЮ_-13H8.XtcoMoӮȒopp~PkմuKi y-h ԩ#  !пJ$/9uwM#V?a0+4c?.;E=<-?rCy-mwy;V=?4hsim/ ̂$o_ Z7Y"UQ rXͬ]. CHOO'OK]V5`B>AEn:GON+𧀴:g_YVY!b8\UFPOVo^" (u~my48r$`N@ QE{Eg%|#Ee$?<xN[=j&F)$,I Wc<*9Us'PG%[ӊG<+z5[Ӭ̺hTKnP%BH5V/T"[kWUbYpw+ aoJ( ~C-sU]Yb\BeC&<9߇z ;i=^˼qPx ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( +.6=/v3[I :;;|sC+W7/E NP 4rڨUm\)';>%QEQEQEQEQEQ\d>tm>kui5K A(f%Br m#(+E_k:ϋ4qO\Gn(tmU$ڽR +Y}'riZ.h_jI% 0Pu]oQÍ'Vծ>}?KSvٝG 8QEQEQEQ\d>tm>kui5K A(f%Br m#E_k:ϋ4qO\Gn(tmU$ڀ=R+Y}'riZ.h_jI% 0Pu@Eq uG4[VEw.Mfu(pWa@Q@V?/4rywV}оvNEx??9iXxJ~Ğ0kT^/t j.X # w2&6 \(򿏺xK.gmN4i-fh)*A@8QEQEQEQEQEQEQEQEQEQEQEQEQEQEQEx]J_KEQbHs; ??vPTz N@dI13+ y>}ޟ<7K٭#"y\T> mۅ'$z,n5?qWZ}07;FFO$lvt/$W27H9C`oJkO ,W-w379lFm8's㮻ycMt=V{?Pm͍O26Vd<>Y?V,q[#1h FpY}kcq| ~]լp̛m ajAo.Y|{wp"n 2*r,{Sx6btOTKvwhLWd OR7T^ě{95{_ZbXː̊Kۜ <)g:lXKkTDԵXui V  vtjEE@z橦j)nr :Uw$` \0>/xWhz^qicw\nl !,AF_$O*ZƋ[uHʿ@.$T0~S [붞ķ^G˱\v^_s +u׃|[wSd[]l*ݎ8G;(_q/-YS1UV߷RCA#wQEx(*?m{x(*?m{s;y_]覮 ?J(ӓY|}跗Xae ؘK":*1J?ÚS㦋xpE22B AΒ\#r@hM{]\sgp:0`AAcԞK6VRl$;)8r Iu w$Ŀ M@_◃|9Iumgyd_erA-߉bsrWWb2x9U Mt<'Ony*O?|G#' 8°Ej&[xWY'Qw! m꣓ESMsY{߾[HW:*X3 WWğ8nM-?P>,j[KZ%ūÏ8cop20GPi0k Ωv-50@]|xTžF$O*Z>ENĽv.OĶziEK@k6~u{kiJ E\ y$ ?JGLj.簵.$(v$)B@'s7\P+cq|(ᵏ̑bI9G<*כ':߉%GōV+)ckXDuQq mF5O& s۾.Ż]^3f /ʕW8Shm55¬W@ ŀ U_x:3>ENĽv.OĶz>0뚥Γ>6,2_x2.<1эg¨ŧMMV[y w )r+ 9V]'xK5TdmpB2rӼG[Wɋ}t1F02͂jO$w=j:ύ}=. [Ydg49+}I.⟉>aF4YLi&yAV+?6cչ;ׇz5W*}AžO;xw<}pu;\(g!Fe$ql8;4| tO v֭]UD}+cc!P|J񾣠g}jUΣp[X _K9&EɾCo7Jj:GsO$ՑVF9Ei |Rā'8?PxιMcᇋOQ\08?|5~5o[&Md"'B.f21#%FGczeQEQEQEQEQEQEQEQEQEq0/%~!ƭ_;^F?獶p]P^g߆KÚӳ]Mk#͹F`K<6ߔ|(3K-f oĚ=Rխfas1![o~^<=ohɻ[7suۍ= ↓O/>ѭgȔn߻6aE8/+\i??oo{T8y-Y{7f[Y ;zg#PO^PZ=LήD|Ұ S xcKA[3r{آ kM{7_5- X>`w( OyEx{O[OvdѦl"l}k<-h>/ikw⦅;˳ OJآ<]IMoQc},4iyjϱ#M2;;ڭy .I' '$5P=Z P4-K$DTdmsF+ ^ZD[Ÿ[ "l .rtr"p0B09k/m=:?2'dF`C FA=+|5IJ޳;X~89$@?/[(<u%ΟYLwWn72 < (! gz/ xJ%]ju8hdb2 7F+/igy^n<䙔`c ($ ((5k0~8Դ(bkkP]1vȣ$0?s\}{O[OvdѦl"l}k(  h-4Z}Zgr9f<SҼ]IMoQc},4iyj(~LvikvC2FI‰2I?z ΍}c|%ђM"*C6#rzuͅ~eO ɸzP>#E\>>El``s9-Ë]IsS=ě̇|d:5 BFx-:6keKfw,GqTѺ2p:rI& /BVz-3^IFf?‚Nɠ3oڞy?nۻf+sТ9cXlg|^^3ܜcv:ƞ[<3ȧ*`,23( Mouoe f;NNNO}[亷E}᙮7 RSiڛY A%rGL (O oi^X})&" !RJ>h潂?t>T {Q@<6\K0DF dOkx_Ƴ;A>EVedn-C c)dgmh+S;ž WٶH5+QKn=="xRnMR HgmQJFs=+jEE^@p~5gfSeKYM#𫝩d^Xpz:xH8JZ+ 92`pcֽ"?6⽂ uxKmdi-ݗ<<>>~Q𷊴6{+#pjlǴH+&xT?k^@o Nߌ?뗞vEIH gnf7:{ݬN#xN? ltݞgցٌ0G^|Y`Z {2GʼzU((((((((WZ}oHaTi$c''((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((PKbwwPKc\EOEBPS/dcommon/cpyr.htmD Oracle Legal Notices

Oracle Legal Notices

Copyright Notice

Copyright © 1994-2014, Oracle and/or its affiliates. All rights reserved.

Trademark Notice

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

License Restrictions Warranty/Consequential Damages Disclaimer

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

Warranty Disclaimer

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

Restricted Rights Notice

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

Hazardous Applications Notice

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Third-Party Content, Products, and Services Disclaimer

This software or hardware and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.

Alpha and Beta Draft Documentation Notice

If this document is in preproduction status:

This documentation is in preproduction status and is intended for demonstration and preliminary use only. It may not be specific to the hardware on which you are using the software. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to this documentation and will not be responsible for any loss, costs, or damages incurred due to the use of this documentation.

Oracle Logo

PK0hPKc\EOEBPS/dcommon/blafdoc.cssc@charset "utf-8"; /* Copyright 2002, 2011, Oracle and/or its affiliates. All rights reserved. Author: Robert Crews Version: 2011.8.12 */ body { font-family: Tahoma, sans-serif; /* line-height: 125%; */ color: black; background-color: white; font-size: small; } * html body { /* http://www.info.com.ph/~etan/w3pantheon/style/modifiedsbmh.html */ font-size: x-small; /* for IE5.x/win */ f\ont-size: small; /* for other IE versions */ } h1 { font-size: 165%; font-weight: bold; border-bottom: 1px solid #ddd; width: 100%; text-align: left; } h2 { font-size: 152%; font-weight: bold; text-align: left; } h3 { font-size: 139%; font-weight: bold; text-align: left; } h4 { font-size: 126%; font-weight: bold; text-align: left; } h5 { font-size: 113%; font-weight: bold; display: inline; text-align: left; } h6 { font-size: 100%; font-weight: bold; font-style: italic; display: inline; text-align: left; } a:link { color: #039; background: inherit; } a:visited { color: #72007C; background: inherit; } a:hover { text-decoration: underline; } a img, img[usemap] { border-style: none; } code, pre, samp, tt { font-family: monospace; font-size: 110%; } caption { text-align: center; font-weight: bold; width: auto; } dt { font-weight: bold; } table { font-size: small; /* for ICEBrowser */ } td { vertical-align: top; } th { font-weight: bold; text-align: left; vertical-align: bottom; } li { text-align: left; } dd { text-align: left; } ol ol { list-style-type: lower-alpha; } ol ol ol { list-style-type: lower-roman; } td p:first-child, td pre:first-child { margin-top: 0px; margin-bottom: 0px; } table.table-border { border-collapse: collapse; border-top: 1px solid #ccc; border-left: 1px solid #ccc; } table.table-border th { padding: 0.5ex 0.25em; color: black; background-color: #f7f7ea; border-right: 1px solid #ccc; border-bottom: 1px solid #ccc; } table.table-border td { padding: 0.5ex 0.25em; border-right: 1px solid #ccc; border-bottom: 1px solid #ccc; } span.gui-object, span.gui-object-action { font-weight: bold; } span.gui-object-title { } p.horizontal-rule { width: 100%; border: solid #cc9; border-width: 0px 0px 1px 0px; margin-bottom: 4ex; } div.zz-skip-header { display: none; } td.zz-nav-header-cell { text-align: left; font-size: 95%; width: 99%; color: black; background: inherit; font-weight: normal; vertical-align: top; margin-top: 0ex; padding-top: 0ex; } a.zz-nav-header-link { font-size: 95%; } td.zz-nav-button-cell { white-space: nowrap; text-align: center; width: 1%; vertical-align: top; padding-left: 4px; padding-right: 4px; margin-top: 0ex; padding-top: 0ex; } a.zz-nav-button-link { font-size: 90%; } div.zz-nav-footer-menu { width: 100%; text-align: center; margin-top: 2ex; margin-bottom: 4ex; } p.zz-legal-notice, a.zz-legal-notice-link { font-size: 85%; /* display: none; */ /* Uncomment to hide legal notice */ } /*************************************/ /* Begin DARB Formats */ /*************************************/ .bold, .codeinlinebold, .syntaxinlinebold, .term, .glossterm, .seghead, .glossaryterm, .keyword, .msg, .msgexplankw, .msgactionkw, .notep1, .xreftitlebold { font-weight: bold; } .italic, .codeinlineitalic, .syntaxinlineitalic, .variable, .xreftitleitalic { font-style: italic; } .bolditalic, .codeinlineboldital, .syntaxinlineboldital, .titleinfigure, .titleinexample, .titleintable, .titleinequation, .xreftitleboldital { font-weight: bold; font-style: italic; } .itemizedlisttitle, .orderedlisttitle, .segmentedlisttitle, .variablelisttitle { font-weight: bold; } .bridgehead, .titleinrefsubsect3 { font-weight: bold; } .titleinrefsubsect { font-size: 126%; font-weight: bold; } .titleinrefsubsect2 { font-size: 113%; font-weight: bold; } .subhead1 { display: block; font-size: 139%; font-weight: bold; } .subhead2 { display: block; font-weight: bold; } .subhead3 { font-weight: bold; } .underline { text-decoration: underline; } .superscript { vertical-align: super; } .subscript { vertical-align: sub; } .listofeft { border: none; } .betadraft, .alphabetanotice, .revenuerecognitionnotice { color: #f00; background: inherit; } .betadraftsubtitle { text-align: center; font-weight: bold; color: #f00; background: inherit; } .comment { color: #080; background: inherit; font-weight: bold; } .copyrightlogo { text-align: center; font-size: 85%; } .tocsubheader { list-style-type: none; } table.icons td { padding-left: 6px; padding-right: 6px; } .l1ix dd, dd dl.l2ix, dd dl.l3ix { margin-top: 0ex; margin-bottom: 0ex; } div.infoboxnote, div.infoboxnotewarn, div.infoboxnotealso { margin-top: 4ex; margin-right: 10%; margin-left: 10%; margin-bottom: 4ex; padding: 0.25em; border-top: 1pt solid gray; border-bottom: 1pt solid gray; } p.notep1 { margin-top: 0px; margin-bottom: 0px; } .tahiti-highlight-example { background: #ff9; text-decoration: inherit; } .tahiti-highlight-search { background: #9cf; text-decoration: inherit; } .tahiti-sidebar-heading { font-size: 110%; margin-bottom: 0px; padding-bottom: 0px; } /*************************************/ /* End DARB Formats */ /*************************************/ @media all { /* * * { line-height: 120%; } */ dd { margin-bottom: 2ex; } dl:first-child { margin-top: 2ex; } } @media print { body { font-size: 11pt; padding: 0px !important; } a:link, a:visited { color: black; background: inherit; } code, pre, samp, tt { font-size: 10pt; } #nav, #search_this_book, #comment_form, #comment_announcement, #flipNav, .noprint { display: none !important; } body#left-nav-present { overflow: visible !important; } } PKr.hcPKc\EOEBPS/dcommon/doccd_epub.jsM /* Copyright 2006, 2012, Oracle and/or its affiliates. All rights reserved. Author: Robert Crews Version: 2012.3.17 */ function addLoadEvent(func) { var oldOnload = window.onload; if (typeof(window.onload) != "function") window.onload = func; else window.onload = function() { oldOnload(); func(); } } function compactLists() { var lists = []; var ul = document.getElementsByTagName("ul"); for (var i = 0; i < ul.length; i++) lists.push(ul[i]); var ol = document.getElementsByTagName("ol"); for (var i = 0; i < ol.length; i++) lists.push(ol[i]); for (var i = 0; i < lists.length; i++) { var collapsible = true, c = []; var li = lists[i].getElementsByTagName("li"); for (var j = 0; j < li.length; j++) { var p = li[j].getElementsByTagName("p"); if (p.length > 1) collapsible = false; for (var k = 0; k < p.length; k++) { if ( getTextContent(p[k]).split(" ").length > 12 ) collapsible = false; c.push(p[k]); } } if (collapsible) { for (var j = 0; j < c.length; j++) { c[j].style.margin = "0"; } } } function getTextContent(e) { if (e.textContent) return e.textContent; if (e.innerText) return e.innerText; } } addLoadEvent(compactLists); function processIndex() { try { if (!/\/index.htm(?:|#.*)$/.test(window.location.href)) return false; } catch(e) {} var shortcut = []; lastPrefix = ""; var dd = document.getElementsByTagName("dd"); for (var i = 0; i < dd.length; i++) { if (dd[i].className != 'l1ix') continue; var prefix = getTextContent(dd[i]).substring(0, 2).toUpperCase(); if (!prefix.match(/^([A-Z0-9]{2})/)) continue; if (prefix == lastPrefix) continue; dd[i].id = prefix; var s = document.createElement("a"); s.href = "#" + prefix; s.appendChild(document.createTextNode(prefix)); shortcut.push(s); lastPrefix = prefix; } var h2 = document.getElementsByTagName("h2"); for (var i = 0; i < h2.length; i++) { var nav = document.createElement("div"); nav.style.position = "relative"; nav.style.top = "-1.5ex"; nav.style.left = "1.5em"; nav.style.width = "90%"; while (shortcut[0] && shortcut[0].toString().charAt(shortcut[0].toString().length - 2) == getTextContent(h2[i])) { nav.appendChild(shortcut.shift()); nav.appendChild(document.createTextNode("\u00A0 ")); } h2[i].parentNode.insertBefore(nav, h2[i].nextSibling); } function getTextContent(e) { if (e.textContent) return e.textContent; if (e.innerText) return e.innerText; } } addLoadEvent(processIndex); PKo"nR M PKc\E OEBPS/toc.ncx Oracle® Forms Upgrading Oracle Forms 6i to Oracle Forms 11g, 11g Release 1 (11.1.1) Cover Title and Copyright Information Contents Preface 1 Why Upgrade? 2 Using the Oracle Forms Migration Assistant 3 Converting Forms 6i FMTs to Oracle Forms FMBs 4 Built-ins, Packages, Constants, and Syntax 5 Triggers 6 Properties 7 Changes to Client/Server Deployment and Forms Runtime 8 Item Types 9 Logical and GUI Attributes 10 List of Values (LOVs) 11 User Exits 12 Menu Parameters 13 Java-Related Issues 14 Integration with Oracle Reports 15 Upgrading Client/Server Applications to the Web 16 Upgrading from Pre-Forms 6i Applications to Oracle Forms Index Copyright PK'JPKc\EOEBPS/content.opf; Oracle® Forms Upgrading Oracle Forms 6i to Oracle Forms 11g, 11g Release 1 (11.1.1) en-US E10394-02 Oracle Corporation Oracle Corporation Oracle® Forms Upgrading Oracle Forms 6i to Oracle Forms 11g, 11g Release 1 (11.1.1) 2009-10-12T21:38:30Z This guide explains how to upgrade your Forms applications to Oracle Forms 11g. PKw9@;PKc\E OEBPS/las.htmF Logical and GUI Attributes

9 Logical and GUI Attributes

In order to streamline the tools available and simplify the development process for building Forms applications for the Web, logical and GUI attributes that are not applicable to Web deployment have been removed.

9.1 Use Visual Attributes to Replace Logical and GUI Attributes

For Web-deployed forms, you can use Visual Attributes in place of logical and GUI attributes to define the appearance of dynamic items.

9.2 Obsolete Logical and GUI Attributes

Replace any references to the following obsolete logical and GUI attributes in SET_ITEM_PROPERTY, SET_FIELD, or DISPLAY_ITEM with an equivalent Visual Attribute.

Table 9-1 Obsolete Logical and GUI Attributes

Obsolete AttributeWhere Used and Upgrade Notes

Alert

Alert text.

AlertBackground

Alert background.

AlertIcon

Icon in an alert window.

AlertMessage

Message text in an alert window.

Boilerplate

Constant text.

Bold

Bold for all items (including check boxes).

Bold-inverse

Inverse bold for all items.

Bold-text

Boilerplate.

Button-current

Current button.

Button-non-current

Non-current button.

Field-current

Color for current text item.

Field-non-current

Color for text item that is not currently selected.

Field-Queryable

Queryable field in Enter-Query mode.

Field-selected-current

Currently selected text item.

Field-selected-non-current

Text item that is not currently selected.

Full-screen-title

Screen title.

ItemQueryDisabled

When a Block goes into Enter-Query Mode, any non-queryable items inherit this set of attributes.

ListItemNonSelect

Unselected item in a text list.

ListItemSelect

Selected item in a text list.

ListPrefix

List prefix.

Listtitle

List of Values (LOV) title.

Menu

Selected menu.

Menu-bottom-title

Current title at bottom of menu.

MenuItemDisabled

Disabled menu item.

MenuItemDisableMnemonic

Mnemonic of a disabled menu item.

MenuItemEnable

Enabled, non-current menu item.

MenuItemEnableMnemonic

Mnemonic of an enabled menu item.

MenuItemSelect

Current menu item.

MenuItemSelectMnemonic

Mnemonic of the current menu item.

Menu-subtitle

Current menu subtitle.

Menu-title

Current menu title.

Normal

Text item.

NormalAttribute

Normal background for windows.

PushButtonDefault

Default or current button.

PushButtonNonDefault

Button that is not default.

Scroll-bar-fill, Inverse, Inverse-underline, Bold-underline, Bold-inverse-underline

These logical attributes are not unique to Forms Developer. As a result, these logical attributes can be overridden by the visual attributes defined by the window manager.

ScrollThumb

Elevator box on scroll bar.

Status-Empty

Controls the look of the empty Status Line.

Status-Hint

Controls the font of any item hint appearing on the Status Line.

Status-Items

Controls the look of the Operator Information Area which contains the LOV lamp, record count, and so on.

Status-Message

Controls the font of any message appearing on the Status Line.

Sub-menu

Selected submenu.

TextControlCurrent

Current field or text editor.

TextControlFailValidation

When an item fails a validation check, it is set to this attribute set.

TextControlNonCurrent

Disabled or non-current field or text editor.

TextControlSelect

Selected text in an enabled field or text editor.

ToolkitCurrent

Generic attribute.

ToolkitCurrentMnemonic

Generic attribute.

ToolkitDisabled

Generic attribute.

ToolkitDisabledMnemonic

Generic attribute.

ToolkitEnabled

Generic attribute.

ToolkitEnabledMnemonic

Generic attribute.

Underline

Underline for all items.

WindowTitleCurrent

Title of active window.


PKSTFFPKc\EOEBPS/repgrph.htm4[ Integration with Oracle Reports

14 Integration with Oracle Reports

This chapter contains the following:

14.1 Overview

Oracle Graphics6i is no longer shipped with Oracle Forms versions 9.0.2 and higher. In addition, the Charting wizard has been removed from Forms. From 11g onwards, the run-time integration of Graphics has also been removed. This chapter describes how you can call existing Reports applications from a form.

14.2 About Integration with Oracle Reports

You can embed new and existing Reports applications in forms that have been upgraded to Oracle Forms.

You can no longer use the Reports client run-time engine to output Reports in the Web. From Forms 5.0 forward, the RUN_REPORT_OBJECT built-in is available in Forms Developer to run integrated reporting in Forms. Using RUN_PRODUCT in Oracle Forms to run integrated Oracle Reports is no longer supported in this release. In 11g, the use of this built-in results in a compilation error.

Oracle Forms and Oracle Reports versions 9.0.2 and higher are now Web-based only, and do not have client/server run-time engines. Therefore, integrated reports in Oracle Forms applications must be recoded to use the RUN_REPORT_OBJECT Built-in and Oracle Fusion Middleware Reports Services.

For additional information about integrating Oracle Forms with Reports, see Integrating OracleAS Reports in OracleAS Forms at the Oracle Technology Network at http://www.oracle.com/technology/products/forms/.

14.2.1 Displaying Reports in Oracle Forms

If your form contains embedded Oracle Reports applications, you can upgrade the form to Oracle Forms by changing the integrated call to Oracle Reports to use:

  • RUN_REPORT_OBJECT built-in (Do not use the RUN_PRODUCT built-in to call Reports.)

  • WEB.SHOW_DOCUMENT built-in

Using RUN_PRODUCT in Oracle Forms to run integrated Oracle Reports is no longer supported in this release. In 11g, the use of this built-in results in a compilation error. The Migration Assistant is provided to help you upgrade your applications to use RUN_REPORT_OBJECT. See Chapter 2, "Using the Oracle Forms Migration Assistant" for more information.

14.2.2 Example

The following example runs a report using the RUN_REPORT_OBJECT Built-in. The report_object node defined in Oracle Forms is assumed to be "report_node1". A user-defined Reports parameter "p_deptno" is passed by Forms using the value in the "dept.deptno" field. The Reports parameter form is suppressed. For additional details about the logic used in this example, see Notes About the Example.

/* The following example runs a report using the RUN_REPORT_OBJECT Built-in. The
 report_object node defined in Forms Developer is assumed to be "report_node1". A
 user-defined Reports parameter "p_deptno" is passed by Forms using the value in
 the "dept.deptno" field. The Reports parameter form is suppressed */


 DECLARE
 v_report_id              Report_Object;
 vc_report_job_id                  VARCHAR2(100);  /* unique id for each Report      request */
 vc_rep_status                    VARCHAR2(100);           /* status of the Report job */
          
 BEGIN
        /* Get a handle to the Report Object itself. */
        v_report_id:= FIND_REPORT_OBJECT('report_node1');
        SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_COMM_MODE, SYNCHRONOUS);
        SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESTYPE,CACHE);
 
 /* Define the Report output format and the name of the Reports Server as well as
 a user-defined parameter, passing the department number from Forms to the Report.
 The Reports parameter form is suppressed by setting  paramform  to "no". */
        SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESFORMAT, '<HTML|HTMLCSS|PDF|RTF|XML|DELIMITED>');
        /* replace <ReportServerTnsName> with the name of the Reports Services as defined
 in your tnsnames.ora file */
        SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_SERVER, '<ReportServerTnsName>');
        SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_OTHER, 'p_deptno='||:dept.deptno||'paramform=no');
        /* finally, run the report and retrieve the Reports job_id as a handle to the
 Reports process */
        vc_report_job_id:=RUN_REPORT_OBJECT(report_id);
 
 /*The report output is not delivered automatically to the client, which is okay
 because the Web is a request model. Thus the next step is to check if the report
 finished. */
 
        vc_rep_status := REPORT_OBJECT_STATUS(vc_report_job_id);
        IF vc_rep_status='FINISHED' THEN
 /* Call the Report output to be displayed in a separate browser window. The URL
 for relative addressing is only valid when the Reports Server is on the same host
 as the Forms Server. For accessing a Remote Reports Server on a different
 machine, you must use the prefix http://hostname:port/ */
 web.show_document ('/<virtual path>/<reports cgi or servlet name>/getjobid='||
 vc_report_job_id ||'?server='|| '<ReportServerTnsName>','_blank');
        ELSE
        message ('Report failed with error message '||rep_status);
        END IF;
END;

14.2.3 Notes About the Example

  • Calling a report synchronously makes the user wait while the report gets processed on the server. For long-running Reports, it is recommended that you start the report asynchronously, by setting the REPORT_COMM_MODE property to asynchronous and the REPORT_EXECUTION_ MODE to batch.

    SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_EXECUTION_MODE,BATCH);

    SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_COMM_MODE,ASYNCHRONOUS);

  • After calling the RUN_REPORT_OBJECT Built-in, you must create a timer to run frequent checks on the current REPORT_OBJECT_STATUS using a When-Timer-Expired trigger. For performance reasons, the timer should not fire more than four times a minute. After the report is generated, the When-Timer-Expired trigger calls the WEB.SHOW_DOCUMENT Built-in to load the Reports output file, identified by a unique job_id, to the client's browser.


    Note:

    Do not forget to delete the timer when it is no longer needed.

    The following example shows the When-Timer-Expired trigger that checks for the Report_Object_Status.

    (...)  
     /* :global.vc_report_job_id needs to be global because the information about
     the Report job_id is shared between the trigger code that starts the Report
     and the When-Trigger-Expired trigger that checks the current Report status. */
     vc_rep_status:= REPORT_OBJECT_STATUS(:global.vc_report_job_id);
     IF vc_rep_status='FINISHED' THEN
     web.show_document ('/<virtual path>/<reports cgi or servlet name>/getjobid='||
     vc_report_job_id ||'?server='|| '<ReportServerTnsName>','_blank');
     ELSIF vc_rep_status not in ('RUNNING','OPENING_REPORT','ENQUEUED') THEN
            message (vc_rep_status||'  Report output aborted');
      END IF;
    (...)
    

14.2.4 Using Parameter Lists in RUN_REPORT_OBJECT

Parameter lists that were used with RUN_PRODUCT in client/server mode can also be used with RUN_REPORT_OBJECT calling Oracle Fusion Middleware Reports Services. System parameters must be set by the Set_Report_Object_Property. The syntax for using parameter lists in RUN_REPORT_OBJECT is as follows:

report_job_id:=run_report_object(report_id,paramlist_id);

where paramlist_id is the same id used with RUN_PRODUCT.

Parameter settings can be any of the following:

  • REPORT_COMM_MODE: Batch, Runtime

  • REPORT_EXECUTION_MODE: Synchronous, Asynchronous

  • REPORT_DESTYPE: FILE, PRINTER, MAIL, CACHE, PREVIEW, FTP, FAX, WEBDAV, ORACLEPORTAL, ORACLEWIRELESS, SECUREPDF, BLOBDESTINATION

  • REPORT_FILENAME: The report filename (not used with CACHE)

  • REPORT_DESNAME: The report destination name (not used with Cache)

  • REPORT_DESFORMAT: The report destination format

  • REPORT_SERVER: The report server name

Other settings are as follows:

  • Reports CGI name is "rwcgi.sh" (UNIX) and "rwcgi.exe" (Windows)

  • Reports Servlet default name is "rwservlet"

  • Reports Servlet virtual path is /reports/

14.2.5 Upgrade Steps

You can use the Forms Migration Assistant described in Chapter 2, "Using the Oracle Forms Migration Assistant" to change integrated Reports calls in your Oracle Forms modules. The Migration Assistant adds code to your application modules that redirects Run_Product calls to Reports and uses the Run_Report_Object Built-in and Reports Services. The resulting conversion is of the same quality as using Run_Product and the run-time engine in Forms 6i.

To manually upgrade Reports in Oracle Forms, do the following:

  1. Find all occurrences of Run_Product.

  2. Identify and locate the parameter lists used with these calls.

  3. Remove all of the Reports system parameter settings like desname and destype from the parameter lists.

  4. Find the Reports node ID for the Reports node name defined in Oracle Forms or the Forms 6i Builder.

  5. Create Set_Report_Object_Property codes for DESNAME, REPORT_SERVER, DESFORMAT, DESTYPE, COMM_MODE, and EXECUTION_MODE in your PL/SQL.

  6. Use Run_Report_Object(report_node_id, paramlist_id) to reuse your parameter lists that had been created for Run_Product.


    Note:

    Detailed information about how to change calls to Oracle Reports in Forms 6i to use Run_Report_Object are provided in a whitepaper on http://www.oracle.com/technology/products/forms/.

PKoJ44PKc\EOEBPS/fmbfmt.htmX Converting Forms 6i FMTs to Oracle Forms FMBs

3 Converting Forms 6i FMTs to Oracle Forms FMBs

Because some properties are obsolete in Oracle Forms, you cannot directly convert Forms 6i FMTs and MMTs to Oracle Forms FMBs and MMBs using Forms Developer.

3.1 Converting a Forms 6i FMT to an Oracle Forms FMB

To convert a Forms 6i FMT or MMT to an Oracle Forms 11g FMB or MMB, do the following:

  1. Use the Forms 6i Builder or Compiler to convert the Forms 6i FMT or MMT to a Forms 6i FMB or MMB.

  2. Then, use Forms Developer to convert the Forms 6i FMB or MMB to an Oracle Forms FMB or MMB. Open the Forms 6i source files in the Oracle Forms Builder, save them, then recompile them; or use the Oracle Forms Compiler.

PK:dW] X PKc\EOEBPS/index.htm_ Index

Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W 

Symbols

& (NAME_IN), 4.5
(FORMS_OLE.) ACTIVATE_SERVER, 4.2
(FORMS_OLE.)CLOSE_SERVER, 4.2
(FORMS_OLE.)EXEC_VERB, 4.2
(FORMS_OLE.)FIND_OLE_VERB, 4.2
(FORMS_OLE.)GET_INTERFACE_POINTER, 4.2
(FORMS_OLE.)GET_VERB_COUNT, 4.2
(FORMS_OLE.)GET_VERB_NAME, 4.2
(FORMS_OLE.)INITIALIZE_CONTAINER, 4.2
(FORMS_OLE.)SERVER_ACTIVE, 4.2

A

ActiveX controls, 8.2
AD, 12.1
advanced converter options, setting, 2.4.3.2
Alert, 9.2
AlertBackground, 9.2
AlertIcon, 9.2
AlertMessage, 9.2
ampersand, NAME_IN, 4.5
Application_Menu, 4.1
Application_Parameter, 4.1

B

Background_Menu, 4.1
BLOCK_MENU, 4.2
Block_menu, 7.3
Boilerplate, 9.2
Bold, 9.2
Bold-inverse, 9.2
Bold-inverse-underline, 9.2
Bold-text, 9.2
Bold-underline, 9.2
Built-ins, obsolete, 4.1
Built-ins, other, 4.2
Button-current, 9.2
Button-non-current, 9.2

C

CALL, 4.2
cartridge, 1.5
CGI, 1.5
CHANGE_ALERT_MESSAGE, 4.2
Character Mode Logical Attribute, 6.1
character mode runtime, obsolete, 7.4
client/server architecture, 15.2
client/server migration, 15
client/server runtime, obsolete, 7.1
command line options, obsolete, 7.3
Command Type, 6.1
components, obsolete, 1.5
COMPRESSION_OFF, 4.4
COMPRESSION_ON, 4.4
constants, obsolete, 4.4
converter.properties file, 2.4
converter.properties, editing, 2.2
COPY, 11.1

D

Data Block Description, 6.1
DEBUG, 4.3
Debug_Mode, 4.1
Disable_Item, 4.1
DISPATCH_EVENT, 4.2

E

Enable_Item, 4.1
ERASE, 11.1
EXEMACRO, 11.1
Exit_Menu, 4.1
EZ_CHKREC, 11.1
EZ_GOREC, 11.1

F

features, obsolete, 1.4
Field-current, 9.2
Field-non-current, 9.2
Field-Queryable, 9.2
Field-selected-current, 9.2
Field-selected-non-current, 9.2
Fixed Length, 6.1
FMTs, 3
Forms 3.0, 4.0, 4.5, 5.0, 16
Forms Listener, 1.5
Forms Server Cartridge, 1.5
Forms, upgrading, 16.1
Full-screen-title, 9.2

G

global variables, 12.2
Graphics, 1.5
GUI attributes, obsolete, 9

H

Help Description, 6.1
Hide_Menu, 4.1
HIGH_SOUND_QUALITY, 4.4
HIGHEST_SOUND_QUALITY, 4.4
HOST, 11.1
HTTPS support, 1.5

I

images, 15.1
Interactive, 7.3
Inverse, 9.2
Inverse-underline, 9.2
item types, obsolete, 8
Item_Enabled, 4.1
ItemQueryDisabled, 9.2

J

JARs, 15.1
Java fonts, 15.1
JavaBeans, 8.2

K

Keyin, 7.3
Keyout, 7.3

L

List of Values, obsolete, 10
List Type, 6.1
Listed in Data Block Menu, 6.1
ListItemNonSelect, 9.2
ListItemSelect, 9.2
ListPrefix, 9.2
Listtitle, 9.2
LN, 12.1
load balancing, 1.5
logical attributes, obsolete, 9
LOVs, obsolete, 10
LOVs, record groups, 10.1
LOVs, V2.3-style, 10.1
LOW_SOUND_QUALITY, 4.4
LOWEST_SOUND_QUALITY, 4.4

M

MACRO, 4.2
Main_Menu, 4.1
MEDIUM_SOUND_QUALITY, 4.4
Menu, 9.2
menu built-ins, 4.1
menu parameters, obsolete, 12
menu parameters, user-defined, 12.2
Menu Source, 6.1
Menu_Clear_Field, 4.1
Menu_Failure, 4.1
Menu_Help, 4.1
Menu_Message, 4.1
Menu_Next_Field, 4.1
Menu_Parameter, 4.1
Menu_Previous_Field, 4.1
Menu_Redisplay, 4.1
Menu_Show_Keys, 4.1
Menu_Success, 4.1
Menu-bottom-title, 9.2
MenuItemDisabled, 9.2
MenuItemDisableMnemonic, 9.2
MenuItemEnable, 9.2
MenuItemEnableMnemonic, 9.2
MenuItemSelect, 9.2
MenuItemSelectMnemonic, 9.2
Menu-subtitle, 9.2
Menu-title, 9.2
Migration Assistant, about batch mode, 2.4.1
Migration Assistant, about starting, 2.4
Migration Assistant, starting in batchmode, 2.4.2
Migration Assistant, wizard version, 2.1
MMTs, 3
MONOPHONIC, 4.4
Mutiple Log Support, 2.1.1

N

New_Application, 4.1
New_User, 4.1
Next_Menu_Item, 4.1
Normal, 9.2
NormalAttribute, 9.2

O

obsolete components, 1.5
obsolete features, 1.4
OCA, 1.5
OCX controls, 8.2
OHOST, 4.2
OLE Container, 8.2
ON-DISPATCH-EVENT, 5.1
Open Client Adapters, 1.5
OptimizeSQL, 7.3
OptimizeTP, 7.3
ORIGINAL_QUALITY, 4.4
ORIGINAL_SETTING, 4.4
OS_Command, 4.1
OS_Command1, 4.1
Output_file, 7.3

P

packages, obsolete, 4.3
parameter lists, RUN_REPORT_OBJECT, 14.2.4
parameters, menu, 12
PECS, 1.5, 4.3
Performance Event Collection Services, 1.5
PLAY_SOUND, 4.2
Pluggable Java Components, 8.2
POPUPMENU_COPY_ITEM, 4.4
POPUPMENU_CUT_ITEM, 4.4
POPUPMENU_DELOBJ_ITEM, 4.4
POPUPMENU_INSOBJ_ITEM, 4.4
POPUPMENU_LINKS_ITEM, 4.4
POPUPMENU_OBJECT_ITEM, 4.4
POPUPMENU_PASTE_ITEM, 4.4
POPUPMENU_PASTESPEC_ITEM, 4.4
Previous_Menu, 4.1
Previous_Menu_Item, 4.1
Procedure Builder, 1.5
Project Builder, 1.5
properties, obsolete, 6
PushButtonDefault, 9.2
PushButtonNonDefault, 9.2
PW, 12.1

Q

Query Builder, 1.5
Query Parameter dialogs, 12.2
Query_Parameter, 4.1

R

READ_SOUND_FILE, 4.2
REPORT_COMM_MODE, 14.2.4
REPORT_DESFORMAT, 14.2.4
REPORT_DESNAME, 14.2.4
REPORT_DESTYPE, 14.2.4
REPORT_EXECUTION_MODE, 14.2.4
REPORT_FILENAME, 14.2.4
REPORT_SERVER, 14.2.4
Reports integration, 14.2
ROLLBACK_FORM, 4.2
ROLLBACK_NR, 4.2
ROLLBACK_RL, 4.2
ROLLBACK_SV, 4.2
RUN_PRODUCT, 4.2
RUN_REPORT_OBJECT, 14.2.1
RUN_REPORT_OBJECT and parameter lists, 14.2.4
Runform, obsolete command line options, 7.3
Runtime Compatibility Mode, 6.1

S

Schema Builder, 1.5
Scroll-bar-fill, 9.2
ScrollThumb, 9.2
search_replace.properties, editing, 2.3
Set_Input_Focus, 4.1
Show_Background_Menu, 4.1
SHOW_FAST_FORWARD_BUTTON, 4.4
Show_Menu, 4.1
SHOW_PLAY_BUTTON, 4.4
SHOW_POPUPMENU, 4.4
SHOW_RECORD_BUTTON, 4.4
SHOW_REWIND_BUTTON, 4.4
SHOW_SLIDER, 4.4
SHOW_TIME_INDICATOR, 4.4
SHOW_VOLUME_CONTROL, 4.4
SO, 12.1
sound, 8.2
Statistics, 7.3
Status-Empty, 9.2
Status-Hint, 9.2
Status-Items, 9.2
Status-Message, 9.2
STEREOPHONIC, 4.4
Sub-menu, 9.2
syntax, obsolete, 4.5

T

Terminal, 1.5
Terminate, 4.1
TextControlCurrent, 9.2
TextControlFailValidation, 9.2
TextControlNonCurrent, 9.2
TextControlSelect, 9.2
ToolkitCurrent, 9.2
ToolkitCurrentMnemonic, 9.2
ToolkitDisabled, 9.2
ToolkitDisabledMnemonic, 9.2
ToolkitEnabled, 9.2
ToolkitEnabledMnemonic, 9.2
Translation Builder, 1.5
TranslationHub, 1.5
Trigger Style, 6.1
triggers, obsolete, 5
TT, 12.1
Tuxedo, 1.5

U

UN, 12.1
Underline, 9.2
user exits, V2, 11
user-defined menu parameters, 12.2

V

V2 triggers, 5.1
V2 user exits, 11
V2.3-style LOVs, 10.1
VBX, 8.2
VBX.FIRE_EVENT, 4.2
VBX.GET_PROPERTY, 4.2
VBX.GET_VALUE_PROPERTY, 4.2
VBX.INVOKE_METHOD, 4.2
VBX.SET_PROPERTY, 4.2
VBX.SET_VALUE_PROPERTY, 4.2

W

Web-based architecture, 15.3
web.show_document, 14.2.1
WHEN-CLEAR-BLOCK, 5.2
WHEN-CREATE-RECORD, 5.2
WHEN-DATABASE-RECORD, 5.2
WHEN-NEW-FORM-INSTANCE, 5.2
WHEN-NEW-RECORD-INSTANCE, 5.2
WHEN-REMOVE-RECORD, 5.2
Where_Display, 4.1
White on Black, 6.1
WindowTitleCurrent, 9.2
WRITE_SOUND_FILE, 4.2
PKqu`_PKc\EOEBPS/exits.htm User Exits

11 User Exits

As a result of removing old-style (V2) triggers, V2 user exits have also been removed.

11.1 Obsolete V2 User Exits

The following user exits, which are hard-coded callbacks to V2 trigger functionality, have been removed. It is now assumed that any calls to these user exits is calling a user-defined user exit rather than a built-in one. Therefore, any code that attempts to locate them is directed to the user exit with the same name in the IAPXTB structure. (IAPXTB is a file that acts as an index to locate each of the user exits that you create at runtime.)

You should recode any code that uses these callbacks to PL/SQL:

  • COPY

  • ERASE

  • HOST

  • EXEMACRO

  • EZ_GOREC

  • EZ_CHKREC

PKLPKc\EOEBPS/params.htm\ Menu Parameters

12 Menu Parameters

In order to streamline the tools available and simplify the development process for building Forms applications for the Web, menu parameters, which are not applicable to Web deployment, have been removed.

All menu parameters are removed from your applications when you upgrade to Oracle Forms.

12.1 Predefined Menu Parameters

Predefined menu parameters have names like UN and PW. Using predefined menu parameters, you were able to refer to bind variables, for example, :UN and :PW in PL/SQL code attached to menu items.

When upgrading from previous versions of Forms, use the recommended built-ins as replacements for the obsolete predefined menu parameters in the following table:

Table 12-1 Obsolete Predefined Menu Parameters

Obsolete ParameterRecommended Built-in

:UN

GET_APPLICATION_PROPERTY(USERNAME)

:PW

GET_APPLICATION_PROPERTY(PASSWORD)

:LN

GET_APPLICATION_PROPERTY(USER_NLS_LANG)

:AD

GET_FORM_PROPERTY(NAME_IN('SYSTEM.CURRENT_FORM'),FILE_NAME)

:SO

:SYSTEM.TRIGGER_MENUOPTION

:TT

Only relevant in a character mode environment. This parameter has no replacement.


12.2 User-Defined Menu Parameters

User-defined menu parameters are obsolete for Oracle Forms. Any menu item that calls the MENU_PARAMETER or APPLICATION_PARAMETER built-ins allowed you to define values for menu parameters.

At runtime, an un-customizable Query Parameters dialog box would let you inspect or change the values of menu parameters. Built-ins associated with Query Parameter dialogs, such as TERMINATE, are obsolete as well. See Chapter 4, "Built-ins, Packages, Constants, and Syntax" for more information.

Therefore, to replace obsolete user-defined parameters, manually redefine them as Global variables (:GLOBAL). The initial value property of parameters can be emulated by initializing your replacement Global variables in your Menu startup code.

For other features, such as the dialog box that pops up using the MENU_PARAMETER built-in, there is no replacement functionality, although you can emulate this functionality by building a dialog using Forms.

PKXa\PKc\EOEBPS/builtins.htmb( Built-ins, Packages, Constants, and Syntax

4 Built-ins, Packages, Constants, and Syntax

In order to streamline the tools available and simplify the development process for building Forms applications for the Web, built-ins, constants, packages, and some syntax that are not applicable to Web deployment have been removed.

This chapter contains the following:

4.1 Obsolete Menu Built-ins

Menus associated with full-screen display and character mode have been removed. Code that contains these built-ins are not compiled and should be recoded, although exceptions are mentioned in the following table. Built-ins that are equivalent to obsolete built-ins are also noted in the table.

Table 4-1 Obsolete Menu Built-ins

Obsolete Menu Built-inUpgrade Notes

Application_Menu

No upgrade path or replacement functionality.

Application_Parameter

No upgrade path or replacement functionality. See Chapter 12, "Menu Parameters".

Background_Menu<n>

No upgrade path or replacement functionality.

Debug_Mode

No upgrade path or replacement functionality. Code containing this Built-in compiles but does not provide functionality.

Disable_Item

Use SET_MENU_ITEM_PROPERTY().

Enable_Item

Use SET_MENU_ITEM_PROPERTY().

Exit_Menu

No upgrade path or replacement functionality.

Hide_Menu

No upgrade path or replacement functionality.

Item_Enabled

Use GET_MENU_ITEM_PROPERTY(<name>, ENABLED). Item_Enabled works in Oracle Forms, but will be removed in a future release.

Main_Menu

No upgrade path or replacement functionality.

Menu_Clear_Field

Use CLEAR_ITEM.

Menu_Failure

Use FORM_FAILURE flag.

Menu_Help

No upgrade path or replacement functionality.

Menu_Message

Use MESSAGE.

Menu_Next_Field

Use NEXT_ITEM.

Menu_Parameter

No upgrade path or replacement functionality. See Chapter 12, "Menu Parameters".

Menu_Previous_Field

Use PREVIOUS_ITEM.

Menu_Redisplay

No upgrade path or replacement functionality.

Menu_Show_Keys

Use SHOW_KEYS. The upgrade process makes this change automatically.

Menu_Success

Use FORM_SUCCESS flag.

New_Application

No upgrade path or replacement functionality.

New_User

Use LOGOUT and LOGON.

Next_Menu_Item

No upgrade path or replacement functionality.

OS_Command

Use HOST.

OS_Command1

Use HOST.

Previous_Menu

No upgrade path or replacement functionality.

Previous_Menu_Item

No upgrade path or replacement functionality.

Query_Parameter

No upgrade path or replacement functionality. See Chapter 12, "Menu Parameters".

Set_Input_Focus

No upgrade path or replacement functionality.

Show_Background_Menu

No upgrade path or replacement functionality.

Show_Menu

No upgrade path or replacement functionality.

Terminate

No upgrade path or replacement functionality. See Chapter 12, "Menu Parameters".

Where_Display

No upgrade path or replacement functionality.


4.2 Other Obsolete Built-ins

The following Built-ins have been removed. Code that contains these Built-ins does not compile and should be recoded, although exceptions are mentioned in the following table. Built-ins that are equivalent to the obsolete Built-ins are also noted in the table.

Table 4-2 Other Obsolete Built-ins

Obsolete Built-inUpgrade Notes

BLOCK_MENU

No upgrade path or replacement functionality.

BREAK

Upgrade to DEBUG.SUSPEND.

CALL

Use CALL_FORM.

CHANGE_ALERT_MESSAGE

Use SET_ALERT_PROPERTY(..., ALERT_MESSAGE_TEXT,...);

DISPATCH_EVENT

Applied only to OLE and OCX items. Therefore, no upgrade path or replacement functionality.

(FORMS_OLE.) ACTIVATE_SERVER

(FORMS_OLE.)CLOSE_SERVER

(FORMS_OLE.)EXEC_VERB

(FORMS_OLE.)FIND_OLE_VERB

(FORMS_OLE.)GET_INTERFACE_POINTER

(FORMS_OLE.)GET_VERB_COUNT

(FORMS_OLE.)GET_VERB_NAME

(FORMS_OLE.)INITIALIZE_CONTAINER

(FORMS_OLE.)SERVER_ACTIVE

No upgrade path or replacement functionality.

MACRO

No upgrade path or replacement functionality.

OHOST

Use HOST.

PLAY_SOUND

No upgrade path or replacement functionality.

READ_SOUND_FILE

No upgrade path or replacement functionality.

ROLLBACK_FORM

CLEAR_FORM(NO_COMMIT,FULL_ROLLBACK)

ROLLBACK_NR

CLEAR_FORM(NO_COMMIT,FULL_ROLLBACK)

ROLLBACK_RL

CLEAR_FORM(NO_COMMIT,FULL_ROLLBACK)

ROLLBACK_SV

CLEAR_FORM(NO_COMMIT,FULL_ROLLBACK)

RUN_PRODUCT

Valid only for integration with Oracle Graphics. Use RUN_REPORT_OBJECT for integration with Oracle Reports. For all other uses, code compiles but generates run-time errors.

UPDATE_CHART

No upgrade path or replacement functionality.

VBX.FIRE_EVENT

VBX.GET_PROPERTY

VBX.GET_VALUE_PROPERTY

VBX.INVOKE_METHOD

VBX.SET_PROPERTY

VBX.SET_VALUE_PROPERTY

No upgrade path or replacement functionality.

WRITE_SOUND_FILE

No upgrade path or replacement functionality.


4.3 Obsolete Built-in Packages

The following Built-in packages have been removed. Code that contains these packages does not compile and should be recoded, although exceptions are mentioned in the following table. Packages that are equivalent to the obsolete packages are also noted in the table.

Table 4-3 Obsolete Built-in Packages

Obsolete PackageUpgrade Notes

DEBUG

No upgrade path or replacement functionality because there is a new debugger. DEBUG.ATTACH and DEBUG.SUSPEND are still supported.

PECS

No upgrade path. Use Forms Trace and Oracle Trace, which are documented in the book Oracle Fusion Middleware Forms Services Deployment Guide (Part No. E10240-02).


4.4 Obsolete Constants

The following constants used in the GET_ITEM_PROPERTY and SET_ITEM_PROPERTY Built-ins have been removed. Code that contains these constants does not compile and should be recoded, although exceptions are mentioned in the following table.

Table 4-4 Obsolete Constants

Obsolete ConstantUpgrade Notes

DATE_FORMAT_COMPATIBILITY mode

Used by GET_APPLICATION and SET_APPLICATION properties. This constant is ignored.

COMPRESSION_OFF

COMPRESSION_ON

HIGHEST_SOUND_QUALITY

HIGH_SOUND_QUALITY

LOW_SOUND_QUALITY

LOWEST_SOUND_QUALITY

MEDIUM_SOUND_QUALITY

MONOPHONIC

ORIGINAL_QUALITY

ORIGINAL_SETTING

No upgrade path or replacement functionality.

POPUPMENU_CUT_ITEM

POPUPMENU_COPY_ITEM

POPUPMENU_DELOBJ_ITEM

POPUPMENU_INSOBJ_ITEM

POPUPMENU_LINKS_ITEM

POPUPMENU_OBJECT_ITEM

POPUPMENU_PASTE_ITEM

POPUPMENU_PASTESPEC_ITEM

SHOW_FAST_FORWARD_BUTTON

SHOW_PLAY_BUTTON

SHOW_POPUPMENU

No upgrade path or replacement functionality.

SHOW_RECORD_BUTTON

SHOW_REWIND_BUTTON

SHOW_SLIDER

SHOW_TIME_INDICATOR

SHOW_VOLUME_CONTROL

STEREOPHONIC

No upgrade path or replacement functionality.


4.5 Obsolete Syntax

Using the ampersand (&) as a functional equivalent to NAME_IN() is now obsolete.

PKXbbPKc\EOEBPS/plsqlconv.htm7 Upgrading from Pre-Forms 6i Applications to Oracle Forms

16 Upgrading from Pre-Forms 6i Applications to Oracle Forms

Forms Developer is upwardly compatible with earlier versions of Oracle Forms, including Versions 3.0, 4.0, 4.5, and 5.0.


Note:

If you are upgrading from releases of Forms before Forms 6i to Oracle Forms 11g, you must first upgrade your applications to Forms 10g, and then upgrade them to Oracle Forms 11g.


Note:

Before converting your forms or menus, it is recommended that you first make backup copies of all files. Once you upgrade a module, the module cannot be opened in an earlier version of Forms Developer.

16.1 Upgrading a Form

To upgrade a version 4.x or 5.x Forms application to Forms 10g (10.1.2):

  1. Start Forms 10g (10.1.2).

  2. Choose File | Open to display the file.

  3. Choose the module you want to upgrade.

  4. Click OK.

  5. Choose File | Save.

  6. Choose Program | Compile | All to compile the upgraded module.


Note:

All form modules and libraries must be upgraded and recompiled.

16.2 Upgrading files saved in Database

In order to streamline the tools available and simplify the development process for building Forms applications, the option of saving files to database has been removed. In Forms 6i, modules could be saved in the database. For all releases after 6i, module files that were saved in database must be saved to the file system.

  1. Open the prior version of Forms.

  2. Save the module files to the local file system.

  3. Upgrade the files as described in Section 16.1, "Upgrading a Form".

16.3 Compatibility with Earlier Versions of PL/SQL

If you have client-side program units written in PL/SQL V1 or V2, you must convert that code to the new level.

Stored program units can use all the PL/SQL features that are valid for use in client side PL/SQL. Certain PL/SQL features such as the supplied DBMS_LOB routines or DBMS packages that are specified as pragma interface (C, C++, etc) cannot be directly called from Client Side PL/SQL. Forms programs must call a stored procedure which in turn calls the routine in question in these restricted cases.

16.4 Forms Developer Runtime Behavior

The default run-time behavior of forms created with Forms 5.0 through 6i differed from run-time behavior for Forms 4.5. The form-level Runtime Compatibility Mode property could be set to "4.5" to provide Forms release 4.5 behavior. (This happened by default in forms that were upgraded from Forms release 4.5.)

Starting with Forms Developer, 5.0 behavior is used in all cases, and the form-level property "Runtime Compatibility Mode" is ignored.

If you are upgrading a form that specifies 4.5 behavior to Oracle Forms, you must alter the logic, as necessary, to reflect the differences between 4.5 and 5.0 behavior. See the Forms 6i online help for information about the Runtime Compatibility Mode property and the differences between 4.5 and 5.0 behavior.

PK1PKc\EOEBPS/img/formserv.gif^kGIF89a  !!!"""###$$$%%%&&&'''((()))***+++,,,---...///000111222333444555666777888999:::;;;<<<===>>>???@@@AAABBBCCCDDDEEEFFFGGGHHHIIIJJJKKKLLLMMMNNNOOOPPPQQQRRRSSSTTTUUUVVVWWWXXXYYYZZZ[[[\\\]]]^^^___```aaabbbcccdddeeefffggghhhiiijjjkkklllmmmnnnooopppqqqrrrssstttuuuvvvwwwxxxyyyzzz{{{|||}}}~~~, H*\ aJװŋ3jȱǏ CI@{$²!o:)g͛8sɳ'2^ (;J:(l|JJիX9bA34u.۷pʝ{ۃ[O>5 N,- TSyt+^̸q|4˫hQx|0≟Uע:MirnG#Xx,1@Fʝͻ"teRI:Ņ @l:ݒjG}=Rxx JTղ˟O$gy/0?|#<IC%k@}F(aC`Ab,2< Տ;̨ 0R2!L@|@Xp &}G#D#FSH L6:tbxr, "BJ0⨨Hh:ZWYrl $dC?N)hrT8cϤƓ12dd9W8Ɉ7Xoa f9h3A̒(1&GAQGMO7c5"?0t)A.?B4?# GBS0Rbȅ+0 (CA1|H;${)C 56!G,!dJ N`]F&HQ ITHЍnC?`EA rhHC a` cRRH%`} nAD"d!(d&pa ppCL` tHđJA zt:0D(8 oP э `v Dy w du@--,K 1Xpbq(C 0p4ءC(=`KUotY8H? 0 P%֑ &b%CM{"Ȃp3\ flP8EݹS~_@> 8S1H9CJ4DDXB=" A1[@!`D"`F$'0 s#" R # FB YDa-K$GAe B 2B*8A hK3>Ã`Ғ *aCxn V=a#Ԁ"q Pc8!#EVeP^RɃPL Ȁh"v4ef0 cxhKzC `@ 4|x@Xq,r]H?  FZ҂KSt-B'6aX ?q w *p! dzPfAփ XR"@ TbIQ XDd9>>-.H%Ј?,btAT0!nG%""=b C7 _!;;A;K0V7#a 1~`g *4 r 4?:>PKOD鷺(Ff /}hA' lBq"  @$hP&@GSIA+e9w" 0W,ԃ{C)` 8T<*7fAAhAL zCD&  IP4XhmU /A 0ې=V4cAz€n* r (h`7ў7I/'ְ@@Ќ#du(2> xPX"p@ ud#֫7](1APrЍY(bXl?!|0NH6hoZ t y0 r6zA7t*e3{ &x(sp P-ui OP !Kp24pD `/Sj 8`#Py W:'m 0sNP PsGzKdA 1x@*@q c@r z JUC` Z@6锃?MGv0 D@t  Jjp TeY {  T/ V P,:p'{X0  iPv`wi֣#i )x?KPa@5ّ P_j5-k 03:fbP3@XP  ֔ 0(!H zA }P.;I~㉠m?\ u y|ٗ~Y0yph'9p#a8 ko`1U>+PmVCe=? p! hC#P`$p\UBh@?O0xʩ 0 0QfxX@ pЉp QA ^ې ys  ɐ ް)1]Yוe0A Ux*9\] Wb;@|h0 .<2 TsН5a C  0v c\!*  ֳ^/T-R Jah:U@ WX3@ E 0 r&uKk:jC穙5fǠcA0 @xw b Ұ)Xj mq @ |00T07kiakw$ pܪd'`:Fpeu P P  PU@v 9ɠ|$O2@  cJ%>1/0fF W0zRb.A`T |& hd  c $ `IY q|PLK[R[[ Ptt% еƀ ` P =y\I 9%4`x)B`ΐ`PRK> m"i0 w  2" 1*) 0zz!@aK= SpP ڀx94p7`@>UG $ ZG[WaʐIPG -; ot ;6 & {AV[Z8`B?`QR eG`&Љ I 0 Qv I ]0#;x <9'`eeU  b@0H o`QSa l ` 7Vdkp#H % {`u  gpb@ P!<g%0<C| ĖhGIW@ ' \P |zH ;` Znabp |X 4VK#Y@ pp VwpA`=Bpc`:t ԰l[L`&6P 2 d  0< K WP Op 8]քrM֓"X|mY clPS׃J! M08r<.р Gw0YPPU`- 6  yPH pq=P{ ݖ1 VG0 m` ` ǀp p@ 2 vq ` @Z P  o  `p `  `@*+d)$ ,>s^> 0SyW@Ը0s `ΰ<7`p k 0`}7rP! p$Bgp r `s =% 7 iP7` F  i0; {P?0<J | y = vBPZ W#P ? 0  `]Y00CPg  m ${8a]a@I$ `CQ'< 8  &yMpG! EN0Ms @ 4lPp <p p@Pp(` ޠ4HP 9@ P ` Ԡ @ `A ` ذuPS;"| P@{`=0p;GpEpÐ0 p40p PW0 Lb0P"qٌ@Ӎ  $XA τ#e [.44(8G 8ȘAW!; $ASH iONXъ?|ڊ:X`@K` $ߜav@=h'!č#G\M!Y[~8-р%/f@ig"cΏ &st'; g57s/5Y)|J)r 1;.odQY"Ȋx =xߥ'g$@C1zZ>(3(0Hn0ArpB *&ب Ņ1ĂDS_?)D!A裏=1vGc.9#h:$裄NIg|la` qÐ&ɠ0F`PňG k`„?q DH/؃ pW/q` H on| >tpDFЋ>xs0“4G1JyXcnT%.xzb@ y$F!:1"m~@ {cqPCi@Bx/80MrKDHAІ=bo6BVF6P`3~YwAQP!5)HS!9\\,6ڙP@'՚(ҁ]1 BP;l<,;0Q`xb!taE3NexA쑇$b0Ef @k:Q{DsGp&(w0/F#_h:mSv0pT-9ЁY\.ڗo,l1G&2| xC( ?rHA@00hi҅14 ͔1 fB Z"ӰDZD@!X+P JU xfaPhp(@9X!KJ K1 |!v :Չ4t", >x B0z~ PDL% 8p!7> OEe9`d(($97D hP r.AF f#'Y21 ,҇ Px r 1hCf/`P7 ?@B1t`r=w2@*&ۣy C?a 8$4 6s}) k`FF da|?"`p# э% ` S#K2 ` dV ,p3Q%bP?r?A@ ?ъLqEptr$\?Z Iz8"/ӻYHR(o%}pH_Ei0E/XBVBGP](-PWD0y2QSc)}O(`xps'hsxFq:k(h Xg8}(U h@pGH) 9h@0fw%(bKZw` Le9|)6{=xhX @Ylq"'}ȆT! 0>v}@BFǤD~N Ѐ-؄k f2"Qh}}p#P@p XHP;D5,x!Z+EY~@yL.ZbЄ5 hPۇh)RH|Md0# H@zP"8(QHS0WIбw9iS;ڳI(RJPI؇WDеy 3I `A{:BI@rM%(&؃^aP( pGPOzHEhR-uKp"ȀD`fP@} d0@8&PPw+{xOH`ȂIxԴpX; d0 xT(0` +JhHGUTr`W8x(!8FkIKa3hJ8=rGm0nP=`J=e3NjI*C81Lf9׬n0W<]dЂ<]zH7t@O6}(W?PӇvMx"!HGj0Sȇy_D`)ȁ0/E[Pnm |Hl8YC,-9`T p|%wWX2 hP8dhձW}pf ?ЂЀ Aalh0#ȁ# 3DX0lhzlJ {vgXKH>1'x ep XeX&h'm0hm/.n%mXee8b ](2 ER`opЇ l30{ywph(`XoPNEpFo`cioxz{(Noppqq/q?qOq_qoqqqqqqqqqq r!r"/r#?r$Or%_r&or'r(r)r*r+r,r$i-rDH@r3wX%23,Xwxap8r Y[>O t؄>Hx`NdEr 2*fh rRPM.Qf&# M~[/.4Ȇ~H+1#s\%e?8kІ4&Dp p) n_\^ f"KmPgs W@tT/8G! (zz8w.BPX p IM_T]@ pm7 `yN sHp 'JH#r}5CA+S(t8H9Hk8`Ѐ5pd 0X-J@ؼ]}؅ϝwp`MZ x-D )L"(AKKye\(-(#v0 []ʟq YUp D@c HBV3eǜ ( 7>XF. vى0+@z0LH2P%Z0V2'@*&jP!ٿ jЀ'Rh"?^I&& Ml >Y"̘2gҬi&Μ:w93f; ?NpXR * YL$_<|gFB)ҐV~Qڿ['EP',\/}m`͢'V&fю cH.~:ɰ`%Ҫ ;"?S7SAMG-o)S:H?d$c|LhB 4.DGxlp\ ? ܤcH&rCpфA`LuP ;B fFO+L1N18#7%ChT7?,\. t3\D 5s@Q'%9F;`X ?59&V@$ s ֤B00ptMEQ# Z7|@Ip` Ql)ⱂPFw# 5Uu7DAP(ճx s7?pϪ!@; t`, (L[8&@o!X8ı 0|\@1 @(*Xpy@ vhG+WB E-|8Slɋ YGƘ4p0#6 q,# L`5Cx+(0(  #B# Gd Roϐ 1Nֱ$@C @#BG.$Q İlXch @G6HRp@]@Ԅ/3 ,QO# ;@;4B='tC8!"R !̷ h H Rb .:^8 @P,"7O?|ЃG5Qi*U!@Ow54b08B䰈OآhGÙ l,'K[܄!!q:~ tnOx?8 3(tJ*dHEZ$ 8 @R<~/!P; c@B0pFT@0Hs APVW! k@\@0A0O^hpAe5 ?Lq0b;bJX$  0 _`P0XK0A*ⱅugQ6@_pv 8C< @ #, 'X ;vq%) !(&!Z`P0A*D˲*@f4 n;%b8|p b8JsC!aZ!@IP (. t+!BWOl @(T/h ͺD@/ p 0aWIHm iC%|> nnƠ a@$6J4BoBZ A-A}5EJ wDt >:\B <1c];ԑ|#eX?α%~tp=Ρzc=ь#ܸ'镡u=d2zB#\h#$z'tpxc JK)ܳU Y <` `BȂhd !"@p*C%PAE:`/|B "2gD/@M+Bqƈ1 @U xAA@j9 G ? 7 )$< \l P܆5D+@LC6X1OaB"0#( AHAPp@+ 5D=@ A"HpA%8[(ME0hB7<"\ceل!LC:$h#7~GvF120h(&DB" |Y `@X/HLa 4!%Az (A|)(?` x NԄEbFrd7R%`Wr0t%e?\âpCNXLx}6@)xB$|)t*"*860B8HAt|AA %d3D NTeFn6f?X mbY_O $Lќ ئM&m\GabTP;~0 <PN%XB& 0",mDpk L?+ F&D+A7A/x&tA)E3HŐ$@)4(3hCAЀ, C>hNhjh"teqB B(xTԃ"t*DB&"$i( B.x =TTVW)2(d#8e@+4APC LA%C( A@A `@|  pBpXaB@ ( X@ @;<<%:2\\BY< q:X0U"4+}}ũ l(PEzAS|x>^:ȇ:B:N<<|D+>Ffr*(xW!P()t%!x?Al*gZ|@h?ILN A*4j<>,>C= #@\D@-kB'|Z*o`@XҎ<0lkBHz@badB9\C8$;`!E?C?%/T<A%TB:d0%AD!|B|sh"xA'B%(P!Bo@MMW (p(&M4 D@ß[09Qp6dA9Ax\5C,6\Nԃ6Ђ"3K?C;D@HT,+@v (6 A(IMٱG=CD?3@4Ľ- @8 82TdI>:w @胼ӄ=tC-$`@ pA!5` #p?(>#tq l@ xX@ā#B2C{P=UIM`Ü}1=c.X2$921ЊW6 6|:B+B1>\<) >tN?C0P@\ tA"B73N8-@tP!B0x; 5A2D3;O=\C*+ЊvID ) <@m|L~IM\ E\_B 6tbD)VxcF-۔& /9č.agD'&p5q;ېB Hnp$#&`7b2>ұP! )tE"P^"3>Knڳ~L(] VAA 5,d,~5H@UTdM֍.P GFS4fʔNxX4d  #@C HQV!H`D pۑL@;%3a "?H,WE{|FL ,PI8 h `Ca SHELa >4q+pbh$ᦹRHCW \R` B(!O!⨃p  BEq @@@pB |7`? 1+t8_`I@.. 2% h&OC PB @!/A00&`Dd=Bp,Dx2p{P%n , PC4% H($}zyA2;Ѕ8 $ HuB'bKhRpI! @b!@"C 7|@ͳ$NF"e}0(BHHǒnG8Cx {VDO@!(`@IUBvA H#e$1p2źEP o~,,!x$@ħbY#">Q(d drJr0+L`VXELQ@@Jb5X?T pgA p0>/h2@. D{Ov89y"`=au,[Lfa.` AT)J $ D|X"( @0l`,`<%z&PL ar 2 =Qzޠb6!   $na a  @ F ` !! (jJ!!zo E\ rVaZ(`l!Z`q'ԁzaB@V ^@Z LR;@!wh d* ֑;H(A DB\J2!Ȓ;A@ x.РA> 8@$d ܀RR4cH` X.C`LA0"ȡ" c2 PX&Qvrp! *8 !f!alR<AZ` 4`R >RYal6T !@dap*Z 3l!l D,N` Faa:!` F I-x DA“!*@f)TAEI2AR #+@N @ :ANpA x@. 6-(R!Ԁ ^@T5 !haơ܊!A!RAa T,FSSB@` ! 6@a`eae[e_ei!eadAD `BR3I1Z ` <x_!.VU aZT] t ! 6` ܠ2ȡ"!xP, @ JjRWuWuS7L@ts 2VzaA(U"ơa0 (D@ a|!akA̡~$a` z2 iI NAahAJ  .5@ (!aR|Un(` l'I/`b_  T4!Rje\aAAAxXv`Bf pBδR ʠ N!s+H"fA:A Ơ lZE``D5;n{@rڨ "@_b2@~ &A·"a䀱AչH@"!A@. "@iI h@ 2\í‰ h< G[;z(#aF Ԁ @ vT@6@(t1 QtYaA ^ P|s;a/z!Gè23c00@ݴK=s:?42N3:@ +(GY$ hp\ 8fq5ʊNJ\ >4E}8 ,LSN;ThjMS;&/tQ!  0h3:F?gz5*0E'NBT4(|RK3sKo7Ĥ[P0QG$7س"f̒>6@ P39,cK(F5| pzP2C6ߌR#,aX0 @pa$ :Ի 8bJ1y4oS/,G;l?t&h9M YЁpEL9=S1K1m* j<$Ê#o-T|tM,\BP"XI?_b(,z j|CnP4T1-O5#vQoG5Dh`6#vP)X@7ҏVyC,JPb0 kpC@;zԃx:đ fd@:z`# $%x H~xB, :#T (G7 cBx*P! Q)Za`HPel 8@^D~l%FO!Da 7*`C`b *y. K|^qV8G*P !`4@@%&(D s<:}H: xs0Jϊ#l@`oH3ڇ3 \`m@\@bzJ /Rؘ E|"u8 kieLv:(P6:Fф, +D@ S/$q(*U/rKnK*}܂ j}ܢ k !;BN E 1D` xccessf4 H kTr k('n rcYN;1v|"䨃.Ej!*\chp`ӞV5 f@)a x"!L@zPC\ ɭH90Ip \h0)! ҝ @4|oMurDcX9 @@z $B% |w</:8 07Hbʠ6ʡ%[DW+-XVT~#=RHƃAU.Q!^.1&cfn3 af"2dLӬ ?Nq4<q{A;H hsg7>@ -$ W6+T(cG)k?i >`U0C 1 W"_mHp"P]'&Fӗ6Q hwK -G> icX/gH*̡ #< h./@ <5oU{ 0kp q @ }   3' )p  v0P-w$~40+@V '&PJgPP#P Y( ߀oߴxP Z@@ a_UR 0GP=`  $ p<`@ P0<`F$P(C`P`pt MP#YKGh0 BN0 ` a ؠ`b `mPJp o4P p @  a pga \5@J 01 O0BMT@ 5 HH Ijޠ5 Jp P% PL0J Q| pp@ @m ` Q@p0  ]8@ rj2a &0Pp P 7 9G vSp @0f0 E/@gb΀ aPT`@GB iJ 20P`@"  k[p# &p{ \@i  PI!s Jp 0 n | 40 /Cp VpPl4gC}D;P L&*p f : U9.~YP e0j0 p8\ `MC 08 ;SQ f- uJ x Ep 5 TP+o ?騎:hP$0.7 PIP t @Ep Z n: p x`4P7`t 0aL0Ő O}<@ @E* ep@?0` %MQz o @  @ v:p%V0 @ 0[pPP PiQ` @`4^ ֠[%2ߐ ?T ,P |0Ձ/ x 0g9P yH2p]0 0 ֐`J_TT ` W0-PLp ⠪ u.`W 08c۰ N@&@d  Po y`PP1 S0s , `=jP` ɰ -_? @`i P p A@PP@ ݐ<Uf_*Pe );:I ˠ iL0&;0M_s ` ILMPNI `@Ķĝ o]`M8#0 01Pl p Pi4J Pǔ=P d1k;Kx 0aP 8pp`pQA2/L  ps6 O[j|P : 琻kBE 0 ##J@!` 3fp p{N2rG0" DPgp p ` N-=p1-ʶ`` p p `f@BPPItp Ђ Ͱ p @c0C0#Л"9@Oh~]@ p qL ;- p~gN07"@4@TPup @WMa  @  p0]H4" C ! Ս.٭۽'P-00[ @0P@PeP΅  Ѐ,P ;>>???@@@AAABBBCCCDDDEEEFFFGGGHHHIIIJJJKKKLLLMMMNNNOOOPPPQQQRRRSSSTTTUUUVVVWWWXXXYYYZZZ[[[\\\]]]^^^___```aaabbbcccdddeeefffggghhhiiijjjkkklllmmmnnnooopppqqqrrrssstttuuuvvvwwwxxxyyyzzz{{{|||}}}~~~,@ H*\ȰÇ#JHŋ3j,x, MCfAG$~cݸq٤M+ X@ʴQ ;xҌ!3?tB *@pЀA .p ANXaF#HpR>M Vr kZnΝo޾}L*^80fL 3_۲g LӨ+ixΠ /g>. 9 up{ 'KvI/uoزc&{e#F~tZo+XTOE>)Psߒ$H>Ȁ2ȁ x`oDiTjQEVX!$>ĉJ1D C= 3  )ppAD B<*5i5i&(afP0S1yB7x3609YA< C0BbKLW8}ÍvLӝ4τL1# z-*򩂊}x_'\&d &0c@ $@y`4%į? 6` -$ۂ'PЂ$$OmDv;w,$ 6oMm<c' ;SM'w\ *a!#N=j9H) #&ð:k, ʲl#DDB8P*4Ç@Q'0VaB9d3A'#2@F7pP$dmeC?:];@@!\R@ DE mNgP>Æ#0.('0o@ ,A!1=bOdf A#G:߰# R: e`P=b?@ t5#7 Q-Cydb 5N8ؒ 9)lB t9LS`P ?QHDhDkE! <m!D9""$!|!5mY(H>ZqR#I/BP$n$K0 jdle-V6p!~hG?F6cH#&z1AFq ]>D 6 ah`@?NQ#?/֡# `@ryHCz@bą-1 Y+Y@Ah>FB@DK5(P AoAYP@Fwq(P~`8:3U1 ;p,@ `z|AB+dE#HZR0X@D%H /& LY_S6D|!{!bȪ##6C T+d B(E*@cex;$pTl?'mB/].@ 0 $wEb w@  wVpw v6X ovp&P'@v  @>00eS @'@"!P^0d'$PPT-  /   P "@`>Q`%@@6Q *cK  tP p9$MEQAWSK8@c7XZgG@SÀ.[U TT`p LP6M- P n|!Pv3! HJ PH@ `  @%p) |^ @/S@~ W d ! O D y e` H |ٗ A kA P @R vP(Ƞ`XI62c!"`~y py3YPpwq J0 3ސ]pY t;y'@0P< d[@ @hP i`P'09 )$` ,E _Vc0 Yy@` Om h q@3a  P9 0n p9P V"6P#k̠۠zJ7 0sZڀ ` p ݀` Sˠp* / x`PY d  0 @0h Кza 0'&1 u@L s! d4zRW0>b` 0 LU3pY &j7=3we p:\Vp3gh 0 0D4yz_̀`T {@  PNac@6^Ц 'KZ^jl Cv`` c0 -de@ Qg xY` ƀ  & e; PX`x@6 # `.рb'JJ$:n@6Rl[{(ca `0zț& 'T Т $)ʻܻ&{`e np۾qP[{ۿ<\| <\| "<$\&|(*,.020Qjm  01 G< fТPIUQD{4XA Fp`L ݐ P À P QyPm@!i@ca^Cip wP P pkT@67|p@^P- fsOqZе: l p1} ڠ0( B (0 ` @ p   q !nkhP_0I0pA@l@;+%c2UW,"2pQy !  'UE!q` a@1'ء0(P ǐ ˀ ɠ Ű V'P ` 1q йP8(9-O)ܫt@}:5m4@ 0ԀE0 D~yB8 R,Ǣ,˲2-%`[b0 @-ABW  0 Qm; @Q @6@ I@JPp (epO@/ @1ˀA+$q8=@ :i6ܹ0P1@Ia24}Ys }vy@ _AFs: /f#E6`` @[]6  j 95Pף23PNj GiDGm$~ gG  : &p7q bp~a`\ m q0h 0 `V'Vℱ&@ N!Pj/0WJg xg`: n^  {ീ50 ~@s P(o` *Rv  @*p0 @ Pd0N; !Кa@ @1%psB@ ^p*h-xp - 00 0qt0,,dвEQGMU`ةi}epQp` °_}Ȃ @```Yf1p8;P ~q kp @E n !M>0Gh n@ P-0 LV>+ p`p `sp:~:Pǭ` !T`/dnӥ$w@#q,_/4ŻI)U.dd(L *T0J(SQNZ?;)cOץAs쁔X}(vbVUcUqPh$?Vz 9Dw3i @1Vkuc ȝl2̚)`!O@7dZ!uU(o9/8<(5se P9~$:n 盓-wbTr&*Oq+Hd$'u7D&bb9%< @GDgHwjad;8F`&GC1F(6 ĪZ r1p0\~ю;C+Āa0zGB自x@ 2g +ڙgJB<4-2pq̐H&}H-ǚJЄNB #z j  nxPj e0gQ"nZƷ$* !fBB*'LqÄf Abnhpd%?xCmgtiFyqDDDa fP}t%}YAxQ$z)R6u%n)yQQAB_*q5= $x` 8@ 8HgK_Rؘ#)A.2}J)t !产̘jL}20 ElT2Ӥ9ehaR8z!`\6t8&Ƥjf% öY($ cD;N[(i,=\  |cȎ3ց`t0 8yy<o)ЀĞ8O0U]B0):qNp0)‚r/U@w4:Q>L+ ǂ$@ءKQ}3I9~C&Mrq`M%5xH0Op#WhE-za oCG;*.G0QRd7a ~B *GHI*0 3%5. F35,\TSj|pj` G, ^ z Sp RS@JM6S*:q eD (+kQUf6G@* %J@ ؂9肕5 :a NZ{" ؀,%nUrtJJ )L@"ĜdȀvrP% C*^h0Д9dW< 38A_@B HЩJ Q ژE 4`_D4*{f(1f ,>\(+j> ` `N d?pjC8E"0D 6eI*g٢h/ҎQ-&ߐ-( (%XբYϳVuUo+3bA\%ta*X4bA ?ȁ:HrC/*ڋȍ~byj?@ a`9Dv8_tTP#t}*yA/*w%xIp "&GJ7> F8 x TYQl@F|-?X`B,!RPbcMz@&` )PaJt^UmQ >jgQm/P r@~}_'~_g~__ @@,@<@L@\@l@|@@ @ @ @ @ @@@j(H;p703)!h0 xp`X"l  @ "P,0h5X?xIR(T[e@imr(vxx}p*/uPK f/Rcx~zxHu(pjxh_WhTNCH?:0/'`%x ?p$:M(/@N =+hCȇ BY؂A \\ M@K3 ]`K {MSXZ`fpl5L7ć @W3,H,3^p6xht Ix`s {yx`dsXroolIkfXLbXIb_xI^YXX`dT8SIQQOJ FPD0?=9x5H2-+p%H$ ؁!(#(Ђ- 3p:B0IPW] hnt`x{9ih'S\: oUP>W@<pI,t(YT sX\ `nvtHFHnɐ|Db``xɗąUPDRxNR,HFHLB>O>;(9x|5H41xÔ*+))(P#@$ 8˳졁@@ xHʊ_Vx%C`@M*xXE Ep)F78duMqHoMl\c`a N_Ѕ䌅V`NUH$"N+KlJ$BA<6' 0 8>^vp HP0Hx PBVI?}jB }9DȀ^؇JCQ BH٩ 0quhwȌ\Crȏ͑,ɓLI$` ^hҚIYxXZU MP:$p0:[xtxBp 0P0#E Ѐ0',K?@؆pp R>(هHX:HpprmdN3XЀ8X5XWPr !(P 0hs#x| A=IP@TEeTh[ _xJ=HA#Ќu`xUx(w6o0SP3P[w҄gp]]55ris[Q|xo\@W P cH@0Yȍ >)qI>E K wv؂ \z V߸=&0 AU0 Et~;0 VX%p87]v@ZHWPؐIC:H%j =y/PƔZ(pphU#jTP#PZ0# !5c` ІHx+_RM(p؁0Ծݞ۞\xza jp W0ޕbrH35R 0+pF"k&#x?[9Xpqi[p^M:` ?K\alX ̅~Piq h5B_828RmʆDhm@al BQaЀ@B|ii 5CƧus %țAy3Ȇl !;ȫjP^~% 0ErPDDnE$udp)8J}@2 TO@$X:`}~G}8l̕rXX?1;x<A!S oHoiɶ(܅O hi[`2Z}718$m؆wbt م*g pfp l3/@.V}jpoi|8~lxN؁E$>wAy"1 ^DJ<0OЅjp`6m;ix%H9m0]:X"xEX| #"Uet(LH?1PE wRގh8;@`؀XN0t`YHF@xg4hܨ!X wX(x5wiyyA87mHp/luya0F؃7rjk Xؾ0h%3GmTpqQ_CYlBF؅p hj1E(pcpdb<7 1p! `|Ftxܳs馊XzA?2gK ؃G@ajmp{ g(g;0P؆^HYPZ @8(W]yrK |pX*x}|z4T(E}1q2nz2 )N0"6jP }F,YLl%̘2gҤ9HLa"TG}g2cF+=砚'!I\ Q љvZe@]יۨD3`H|оdAT0 8 'Fr ! )dkI@Xk† a6n 6ܺKʛ32nk/Z9bS K!dvᆦ?4QyVF[%+I'.jppAC279>@1pUgfJ&RG IM!"{lM"$>s#|aG 9# ICHW L@ &M33F2tHLip )AL&4 \a$ހ?z+ ŒhNjP&2b--yMS f4W\oI*lI Faxb6G6:P HpᰖZImA 8['%8`$ X@ch ĀD9bE/XqA D@L>5pA "P$k6S``6p ,5@2a0:ZvYh04LxLfEKՂJ'pʤ@Kl8CR`fWxQT١  xFZPn (}&#@05MV7e0bpt4rpv,jHE ǎY?r cG! 1t$|,C#!R &HE0PPs"xDhLrKCChHp j؃!$O\Z(!0H` 0nb< ҆k`Hp >J#Q-2/B>E@<<>y g]*1!0 9+^k0c sbO@!!4p& 0ؽD:,@.ȄPZW3B't'|BL@BM\C)MaLăT ԃ9L DTA&1 8A'%+PL虥 E?xA&)N'AQDC"7L0Ï;xSA$(ԋt'PAD(3""LAX?@M't&X'xA\!`Ε 2]4XY5CD9$3U- ! A-["#2ĜiOLXU.0@ RE8TA)ta'\%\B&T"dD3O(C8@E7@B@|A-w2LpR'O2$A&hYHm,Cf%Ld&D;)WM<@ w|C(`\YB2$dlL 0mBB&N%]  ;v_=IAt Ā(0&-5x9KΤ\>/,Y #nQ''lB'DBDAA@#mC3(Dh6>TUFQ;>\&$+Z )lA A1YRC"PKn0x8@^0$i.l`Cȃ/A +C@%KPWWC&@!Lx s֧n0 0MC4@(@<X^6+, P^|' 18"G.X]!+L7B$l}A'9tf`B>>t,(ԁ$C9H $&.gtFgЁ(84.B#A d-Tÿ1A(&땎H.tA(ƺ (&iP7,&ALD78 $$5A*'A"Ђ$@UJ0$/7AV>4¶݀0X>X@:Y8LB1hꥄC"&\e"A'܂ދ7tw@&/XZx^< WPB `P`'@ ÉZ?,䀟& #x ޺D2>l%^W@@>7 y,4RL@C@%..C< H\@? <8C $TP4@80E ?@o,CL=(X-=|TšX1KX19h@j  3N- *?Bz = AS)flQ$X ;PP7Bz4$GrW<,l D'/h).gA\>R)( p$DznCRl)D=C?4CK3 >P;AHAeʲ4Ql9sKh Xp?7tGtO7uWu_7vgvo7www7xx7yy7zz7{{7|Ƿ|7}׷}7~~7788'/87?8GO8W_8go8w888~cd5tv5$6 AXAA D#hB)B,.1 5TC69<ȃ=>_J"%_pHu"ܸL>C<뀃7L5<1/-'$0"Aԁ` h@J($0pNG\ @$TfA !T$xB*-.2,5`79==,2dAD<}Hg$>>:7x7DC400 C.B,`6B"AhD5@ X`XD@t:$@@T\p@ @0dx ,B&`*VAB 4I@,!|c7?tg_B>贛D1C|CZ˃nE8I$I$rv7?|@@/5+pA$%سDlk*Psz K3:CuIC04 Lݳ1,dF,{&gw0SgDC(!hPCքy\fȶXX z$M#NFZ.BYS>;:X#<O1P- (8 $@!x$,L[HNMB$ZdKBauk1٭>$g,0k:V3θ mpOK\`[ͷz+N_w>Î;У:4L`0PxɆ`?aJMX`˟]g;'@ejr%f"طhy`dy@&ˈ,2$<4'raJٰmR02!EyFAD<ˆB0@DЃ,:2$Ԥ*uqS,A8pN% BH*A@GBpeA5! A-xoGQB@bP < WÖ-р4BMXרk6ͻtsR]c)>a F V 4ApZT8™/G!d"bp2Н`e, tF$7r 1UУ+ ;P2ZЅ!Z9:a^{jX#_BE0 YBHl  I%rxœ4Wes< L`bh !n-]?<Ąg;bݑ$[4=6S=$IIԘ4aiX(.VA<|- Ƞ n+1g1w0AIݠdO)u`;Ē8X()3Q[bl8G:6xcG4|aF 6 j`*Mf HI dJ"5 `a&J~+VAxGѺWo)ǂ RLP3(A|@,AZ!\A9-u6S8@6^Yb+@VQ;P ebL@ -XqcG; P! A@] _*XC : .3&B؊&rA_jY0C8ci)-Qy!RG< S HX a+_MCPe S2d,ٲ t0VbF`v*Nac0C͎&!pD rp cbmhB 8+[8mXH`C`t!Jl4ƒ.ъ@v! s#P3Eop!g@/B`О0;WIP.f":̺% f#̀ `xz@pT[&'<@?A'r0#d՜ɶ܀&`ZuPTaPjㆧ1ցeaPP~3@ mV|qb+,Mt8҇jeXG0s [QRPY@#htu;*1X`х|:2 f8CVձ3yC\@h @-La@ @ `+0Pn+ I D #a+ܡ,j` *ޮL`6p NFLL*$@),A- 5Z`Xe* bҠA6-z `+\" A,P  v`t jA!PtJB`0 CF4UA|A-"A!A8.„a+Z@!`ҁ nB> !aKY|-@ ˻t@- J] 8A`/`4VFXUp B, R,"4@ AR A *Z=EtP 6`l,4*ZG*R**!+XBkOC.4A)[H+jAa >m,@ a|!4x &ƀaF@L@/`a$>qDQO`+puN4*W*‡|Ahd+!,7$t,Cf)-!-a .!x )!a ƫ(/n,,*.)*]u!j.A oSC6$niJf a P?I?~+,~+:ή®lXA !!lMl(Ao$ҢΑZ@ ^y*@ z *  ^H\jNffDi+Z! e ttl6aCzf@,a KBה rVa>`a l@BA`!NR+nhdoC. (-BU`   R @hNAdtnHPAx`i\0|! l!hRV́`A@a5S 31RgaJ2^` 'v@Bdv `A  vKE!j a >ܐ+Ѐcɔ\ SSFS,DC*A.@!x斡 LA+!H Pab`t jdl"VZA¡Q3dFo.""a.!JwCX!f^av .g`؁f@`A" ^@ ^ *aÊj<44(IC ^҂~|`RN  !4a]וv2 BF z`Vl>-AdՂ$.+aaAjAabCQ7:i` A@Xz`raD|@0 A.@~A`@ B F`z 41Yei3՝*Vv- - w-+Aa,O+j5.x@@yb4`bQ7cCF El_)-!` 1@ /  Z@ BV!tA. v J` {iD{AX\kOlSl+ `n-"xæZڨڨ08a}b| NA&ё+Nc5xqFfҡtN- (Oa^`8@@ 2+- X`d@ !N%|+a2*7tة(-l-Fb%c\!i,Ѹ`怫Q!`8u1poC!,q-$rR@ A@l@A!,J  8ܠ8!y  ZGQDA "3* J-+X([,ܱK-Ppa ;ay,INC@g"v+a^! ƣAHʽ*a p@>Zliء R+afX!0"EaתaM@F1>+`&.JbKƽʼ-t! apAءrڈ| C!E$nF@7Ղ 4TӽAa T`+`z^vEPTvX ru0aZ@5A~7!U-Z;x/A+! h v+ȁ<."@P}6S " IIHXb!@NaABֻ;1A-}+l]Y},2 <0aAk2a76 Caulb™ g-Y/Y29:"A!@! *hCTE5֭\_Iuvў9vi 9>:=y /!E}Ӡ)k:1ϨHn  j vɰKy!W?jl*&N<} F9(€FZm@Գ_4F j:ӆ=!][N`SxH^h- 7~`pOT ps]`?I)  PM'`I&חn9ԓ#%R\e bFG83;SGL7(@})CXW8A-sdA$x;);ȢPCQ q d @B$,xtN)D)> pP%\SPVQ EJɂ}X3d7+f+[3W`E/p\È$ԁ S7b?|d@ M/ w"R4U#\sE AyÅ'G5 WV/Zs$Y1BBG^>֝0dUP<ׄŎ @=r( AЂ̀AR-o Q:~Z:(~MC]y}B?U;x+\!Vp4Ps7 *}d#$N <303C4))x 7TBH?`w,th! # ^RԼ( !qVl+tjG!y] #lA+NFQ 8X !uXE4pZ! @)2;Ka `B-pJ*qpW 5?>`+p3:x b`cy Lo FA !Y| Nx1DS0H"@"+q0t*)Z2,B!M4R;8.+p@- 0MHI20Lc 'x'Vxc(X QHh;C$WQ Rh[4jVj0})@+"-Ȝ<-<9 O,:$pQ2VVX!hi VZ@QCAt4h`7QdFłP,-Ѓ Psb*Ft 3WqR`EF DL x< nB*B F@I k\X a0E@-π0 *.0p)(p[c]V|]D?aQq `iאQ,# g p43*p:ABWr q Jfk3` pG A^6S2#`TP`PP: F`khVP( #Q "ӅX0 #QQ p D")ɤ@ 9 !:ߠ @ pg + X)] !p;,Ц$ EP9 N`1 GQQ `Ӥ := #ךH>H@t 4q(Cq k .`` ɷ bp(@6q ?Đt*[y1Tp }9- _ p nfD 3e4!0 90-f&jiyzt [ 79 `EP ` fP a jV Y @xQf#upO0 i] X ~ߜ` Ȑ+{0 ?PPVi!\[Kq - 0P kB0yQ 0O2bh cf`h@c/k U4P[1-Oa f0 f~>DGR @Qq ` `  !h_ !<]u= Ơ Oµf7ð탔 ==NhP&p|U,]p =n .MP7נ6慑$f, 0}}UBvȨmPn PfUP0Py!`:f"pАG_<&@Ӹp+@ Ɛٛ  [Z@ 0MH?C E0(? =p r0pw@|2 nNPju^0sOMpħ@ } S |` hR0/@ T0; .|>Z nN1` #;Xw` DPsp q@7PO@ K4gPD+X;,~Q@DRJ-]< 2e9hYIlDc+f16ՄZ $WK"dת;e͞E֢? Kr`G`R{ ݞ-rMWfut @qA:7_ƜYsA88.+9C?0@-90A 7IV0:I'ăI"wpL`CȞ[@%V$u"1?ZX!p̢b 0%m ` @dM9 ڠRS"wdrx UAJ0@OQ$4VY'ZGHX>8bWѧ~P E =PQIOļi$̾I@Ye"v H!`Es)Z'X1.F8(0YV%r:A` h^` 21 i7d+j'K˜!4aTq$x~ę .8@$ )#5"zP€򨦾7tj-:G/Pj6A2,+mpdm@+f7%"'vDR:qYgIAA789&U``a,X)@>002x`" .1s6g2JlHIxEq'Ar-ɥ9DzPRf2T>Y W+{^(@7h^f1CD a8 %P4 #d(Dؒed BPϮLh<氇iF-2:HWR X+Љ"0Fhc]  P?4b`-t \D$ hX@ 49>Z("D(қAvl 0v=wA XsHb ?c 69H!/G1ܰ@wj8P3XPl ~q!'E?!ABeBS|IԨ`U -Ra!FDʀ2jxr(ce'8ьCd /ҨBB9<1fz!20J-"fQ&rDqx04(HD pQCVH?! ʣB Qy^MTlAH!ND -Ȍ68o, !ioа M( ~H/&@b x@"qX8?^`?pHwg! Ԡ}8@`n-D YAvDGjc  [dpjk~xaB0(0a'r0oˏqe⁇'a@ILxq$` ̈R y@(i# p=8`H<\>r $H2Eq4t6};:!F#Z1̄ &A].G1 B"q/'; XP=r54c`6' -pG$i"$ ІJ Rz 2R aB-숞 $@ x-fYSĬ"xCQgO Y" rfqP`T p#T| YF?,_ilߘH.!d.|b ?v`qCX,61U iS7XAwUK/0| !Z[Ĭz@]׽>.F C"~Ls8B `q<LG% &-: M>h%=ao=MxG2"%P: b&S˂ /.p'F} KY#` 0P0C(`8`'yX<< <,F NAkE@txxV:u\F;:(0.\X0,{'< {q@Kb.jQk B\'Hx^6D ` 4x|b0EHF@/x;`%7dDxpZڿMRX<S(qh:HO[3jT~=hhH|ExzC1!SaiuAig(8F(b,$̸-M oDAЀhx(a8E8ȃEXfZ܌NpG25G8b{mlK:BL {@IP!t( ɘMPh@%kp"ɠ:yTa0-hZʨ] 48@PJKAp&`~x˖x%+$xh|~ؐL iP<-`39ô̚/ h PǷ` E@DͨP=ʲ ʹh<@0h8 NHTcz Ralz 0S } OHWCds(Ђ lh'zZ k`t S@px sh_SLK (7L8 8Mk긁I Mz( U kPh(w2Rq$,` ,`4!&M9Q.zO/1%253E4U5e6u789:;<=>?@A%B5CEDUEeFuGHIJKLMNOPQ%R5SETUUeVuWXYZ[\]^_`a%b5cEdUeefughijklmnopq%r5sEtUu;PKgVzzPKc\EOEBPS/migtool.htm{) Using the Oracle Forms Migration Assistant

2 Using the Oracle Forms Migration Assistant

This chapter contains the following sections:

Go to http://www.oracle.com/technology/products/forms/ for the latest version of the tool.

2.1 What Does the Oracle Forms Migration Assistant Do?

The Oracle Forms Migration Assistant updates obsolete usage in your PL/SQL code in order to upgrade your Forms 6i applications to Oracle Forms 11g. The tool issues warnings when it cannot make the required changes automatically. This tool has a command line and a wizard version. The Oracle Forms Migration Assistant does the following for all Forms module types (including object libraries and PL/SQL libraries):

  • Updates PL/SQL code where possible, for example:

    • Updates RUN_PRODUCT to the RUN_REPORT_OBJECT built-in when used to call Reports.

    • Updates CHANGE_ALERT_MESSAGE to the SET_ALERT_PROPERTY built-in.

  • Provides a list of obsolete code usage, including code that the tool cannot change when there is not a straight-forward equivalent for upgrade, for example:

    • Provides warnings when specific obsolete built-ins are used at run time, such as ITEM_ENABLED.


      Note:

      The Oracle Forms Migration Assistant replaces built-ins and issues warnings about built-ins that exist within code comments.

  • Provides warnings when obsolete functionality is encountered, such as when obsolete item types are included in the code.

  • Provides warnings about triggers defined at incorrect levels.

  • Replace simple one-for-one code strings such as OHOST to HOST, MENU_CLEAR_FIELD to CLEAR_ITEM, and MENU_FAILURE to FORM_FAILURE.

  • Performs more complex substitutions such as CHANGE_ALERT_ MESSAGE to SET_ALERT_PROPERTY built-in, DISABLE_ITEM to SET_MENU_ITEM_PROPERTY built-in, ITEM_ENABLED to GET_ ITEM_PROPERTY built-in, and ENABLE_ITEM to SET_MENU_ITEM_ PROPERTY built-in.

  • Raises a warning in the Form module's log if V2-style triggers are found.

  • Raises a warning in the Form module's log if built-ins related to obsolete object types are found such as VBX.FIRE_EVENT, VBX.GET_ PROPERTY, and VBX.GET_VALUE_PROPERTY.

You run the Oracle Forms Migration Assistant in batch mode. You can re-enter the utility as needed to run the upgrade process on a Forms application more than once. You can also use the wizard version of the Migration Assistant to upgrade multiple modules.

By editing the converter.properties file, you can set options before you start the batch migration. By editing the search_replace.properties file you can specify the strings that the Oracle Forms Migration Assistant searches for and replaces, and edit the warnings that are issued when an obsolete built-ins is encountered.

The tool creates a log file so that you can navigate to problem areas in the application and make modifications manually.

2.1.1 Multiple Log Support

The Forms Migration Assistant allows you either to write all log information into a single log file or span multiple log files. If the Forms Migration Assistant spans multiple log files, the Forms Migration Assistant generates individual log files for each module that is processed.

You must specify the directory in which the Forms Migration Assistant writes the log files. The name of the log file which is generated is modulename_moduletype.log.

For example, if you process a module by name, such as test.fmb, the name of the log file is test_fmb.log. If you select test.fmb and test.mmb for upgrade, the Forms Migration Wizard does not overwrite the log files. However, if you converted two modules test.fmb from two different directories, the log files are overwritten. The Forms Migration Assistant generates two log files: test_fmb.log and test_mmb.log.

2.2 Editing the converter.properties File

To change upgrade options, edit the converter.properties file in a text editor. You can set the following upgrade options:

Table 2-1 Oracle Forms Migration Assistant converter.properties File Options

OptionDescription

Log File Name (default.logfilename)

Specifies the file name and location for log information.

Reports Queue Table Installed (default.usequeuetables)

When using web-based reports, these queue tables are used to monitor queued and processed reports. When used with the Oracle Forms Migration Assistant, the queue table provides detailed error messages when installed in the application schema. (For example, if a report cannot run due to uncompiled PL/SQL, you can use the queue table to query for full error messages.) The resulting report is automatically printed. See the Reports Services documentation for more information about the Reports Queue Table.

Reports Servlet Directory (default.servletdir)

Specifies the name that has been defined for the virtual path used for the Reports Servlet, which is used for running reports on the web. This setting is required when converting Run_Product calls to Run_Report_Object.

Reports Servlet Name (default.servletname)

Specifies the name for the Reports Servlet used for running reports on the web. This setting is required when converting Run_Product calls to Run_Report_Object.

Reports Server Host (default.reports_servername)

The name or IP address of the system running the Reports Server. This setting is required when converting Run_Product calls to Run_Report_Object.

DESTYPE (default.destype)

The type of destination device that receives the report output. See the Oracle Fusion Middleware Reports Services Publishing Reports to the Web for details.

DESFORMAT (default.desformat)

The printer driver to be used when DESTYPE is FILE. See the Oracle Fusion Middleware Reports Services Publishing Reports to the Web for details.

DESNAME (default.desname)

The name of the file, printer, e-mail ID, or distribution list to which the report output is sent. See the Oracle Fusion Middleware Reports Services Publishing Reports to the Web for details.

Reports Server Host (default.reportshost)

The name or IP address of the system running the Reports Server. This setting is required when converting Run_Product calls to Run_Report_Object.


2.3 Editing the search_replace.properties File

The search_replace.properties file contains the strings that the Oracle Forms Migration Assistant searches for and replaces. It also contains a list of obsolete built-ins that generate warnings.

2.3.1 Adding Search-and-Replace Strings

You can edit this file to add your own search-and-replace strings, as follows:

  1. Open the search_replace.properties file in a text editor.

  2. Go to the end of the list of search-and replace strings.

  3. Add a string to search for and replace using the following syntax:

    SearchString|ReplaceString
    
    
  4. Save the search_replace.properties file.

2.3.2 Modifying Warnings for Obsolete Built-Ins

The warnings for built-ins have the following syntax:

<class>.Message=<WarningMessage>
<class>.Warning1=<BuiltIn1>
<class>.Warning2=<BuiltIn2>
<class>.Warning3=<BuiltIn3>
etc.

For example, for the class obsoleteMenuParam, the warnings are coded as follows:

obsoleteMenuParam.Message=Menu Parameters are no longer supported, the parameter and usage of %s should be replaced using a Forms parameter or global variable.
obsoleteMenuParam.Warning1=MENU_PARAMETER
obsoleteMenuParam.Warning2=QUERY_PARAMETER
obsoleteMenuParam.Warning3=TERMINATE

<class> is a group of built-ins that have a common warning. <WarningMessage> can contain one variable string (%s).

When the Oracle Forms Migration Assistant finds a built-in for which a warning should be issued, it logs the warning and replaces the variable string (%s) with the built-in name.

Classes included in the search_replace.properties file are:

  • obsoleteItemTypeBuiltin

  • obsoleteBuiltin

  • obsoleteMenuParam

  • obsoleteItemTypeConstantProp

  • obsoleteConstantProp

  • obsoleteConstant

  • obsoleteHardCodedUserExit

  • obsoleteComplexBuiltin

  • DataParameterWithReports

  • NoErrorOrWarningFromForms

You can add more built-in warnings to an existing class, or create classes and warnings:

  1. Open the search_replace.properties file in a text editor.

  2. Go to the end of the list of warning messages.

  3. Add a warning to an existing class or create classes and warnings using the syntax described.

  4. Save the search_replace.properties file.


    Note:

    Do not delete the last two commands in the search_replace.properties file.

2.4 Starting the Oracle Forms Migration Assistant

You should upgrade the common modules (such as OLB files) and Libraries (PLL files) that a Form relies upon and ensure that these are available in the FORMS_PATH, before running the migration assistant.


Note:

For UNIX, an xterm display is required to run the Oracle Forms Migration Assistant.


Note:

The forms\rp2rro.pll and forms\EnableDisableItem.pll files should be in the FORMS_PATH in order to convert RUN_PRODUCT to RUN_REPORT_OBJECT.

In UNIX, set the variable FORMS_PATH, such as setenv FORMS_PATH $ORACLE_HOME/forms.


Table 2-2 Oracle Forms Migration Assistant Command Line Parameters

ParameterDescription

module (required in batch mode only)

Specifies the module to upgrade. The module name parameter can take only one value. For more information on upgrading multiple modules at a time, see "Running the Wizard Version of the Forms Migration Assistant".

log (optional)

Specifies the log file to which the upgrade results are written. If not specified, the default values from the converter.properties file are used.

mode (optional)

This option has two values (batch and wizard). Use mode=batch to run the Migration Assistant in Batch mode, mode=wizard to run the wizard.


Information about the progress of the upgrade process is displayed on the screen. It is also saved to the log file that you specify in the converter.properties file. (To change upgrade options, see Editing the converter.properties File.)

Check the log file for information about required upgrade steps that the tool did not modify. Manually make these changes to your application.

2.4.1 About the Migration Assistant in Batch Mode

You can convert multiple applications by running the Forms Migration Assistant in batch mode from the command line. Batch mode is useful for converting multiple Forms applications. For example, on Windows, create a batch file (for example upgrade.bat) that contains the following:

for %%f in (%1) do frmplsqlconv module=%%f userid=<connect_string>

Then run the batch file as follows:

upgrade *.fmb

or

upgrade foo*.mmb

On UNIX, create a shell script (for example upgrade.sh) that contains the following:

for file in $*

do

frmplsqlconv.sh module=$ff

done

Then run the shell script as follows:

or

upgrade.sh foo*.mmb

2.4.2 Starting the Migration Assistant in Batch Mode

You can run the Migration Assistant in batch mode on Windows and UNIX computers.

2.4.2.1 Starting the Migration Assistant in batch mode in Windows

In a Command window, issue the following command:

frmplsqlconv mode=batch module=<filename> log=<logname>


Note:

A dialog window appears recommending that you backup your files before converting them. Select the Show me this again box to enable this warning in the future.

where <filename> is the name of the file you want to convert, and <logname> is the name of the log file that is generated.

The Forms Migration Assistant looks for the file test.fmb in the d:\temp directory and names the generated log file test.log and places it in the d:\temp directory. You can give the log file any name you want and specify any location you want. By default the log file is written in ORACLE_HOME\bin. The module parameter can take only one value.

In the following example,

frmplsqlconv mode=batch module=d:\temp\test.fmb log=d:\temp\test.log

the output of the conversion is displayed on the screen. It is also saved to the default log file. Note that in batch mode, all converter options are taken from the converter.properties file. To change the converter options, see "Editing the converter.properties File".

2.4.2.2 Starting the Migration Assistant in Batch Mode in UNIX

In a UNIX shell, issue the following command:

frmplsqlconv.sh mode=batch module=<filename> log=<logname>

The output of the conversion is displayed on the screen. It is also saved to the default log file. Note that in batch mode, all converter options are taken from the converter.properties file. To change the converter options, see "Editing the converter.properties File".

2.4.3 Running the Wizard Version of the Forms Migration Assistant

You can run the wizard version of the Forms Migration Assistant and edit converter options.

2.4.3.1 Starting the Wizard Version of the Forms Migration Assistant

This section describes how to start the Forms Migration Assistant on Windows and UNIX computers.

  1. On Windows computers, set the FORMS_PATH environment variable :

    SET FORMS_PATH=%ORACLE_HOME%\forms

    On UNIX computers, set the variable FORMS_PATH as in the following example:

    setenv FORMS_PATH $ORACLE_HOME/forms

  2. On Windows computers, from the Start menu, select ORACLE_HOME | Forms Developer |Oracle Forms Migration Assistant (GUI Mode), or at the command line, start the conversion utility by entering: frmplsqlconv.bat mode=wizard.

    in UNIX, enter frmplsqlconv.sh mode=wizard.

    The Conversion Wizard Welcome dialog displays.


    Note:

    You can get help by typing -h after the command, for example, frmplsqlconv -h

  3. Click Next.

  4. In the Modules dialog, click the Add Module(s) button.

  5. Select the modules that you want to convert.

  6. Click Next.

  7. In the Converter options dialog, enter the location and name of the log file that is generated. A browse button is provided to assist in choosing a location.

  8. If you have Forms that include embedded reports, fill in the remaining fields. Otherwise, you may ignore these fields.

  9. For more information about the Reports fields, see Oracle Fusion Middleware Reports Services Publishing Reports to the Web. For more information about advanced converter options, see the following section, "Setting Advanced Converter Options".

  10. Click Next.

  11. In the Finish dialog, the modules you selected are listed. Click Finish to start the conversion.

  12. Progress displays in the Log window. (Log output is stored with the log file name(s) that you specify in the Options dialog. See the following section for information about setting options.)

  13. Check the log file(s) for information about required conversion steps that the tool did not modify. Manually make these changes to your application.

2.4.3.2 Setting Advanced Converter Options


Note:

For information about setting the search_replace.properties file, see "Editing the converter.properties File".

You can set conversion options before running the wizard:

  1. In the Converter options dialog (step 2 of the wizard), click Advanced Options.

  2. Converter properties display in the left column of the dialog. Edit the property values as needed, as described in Table 2-3, "Converter Properties":

    Table 2-3 Converter Properties

    Property ValueDescription

    Display Backup Warning

    Determines whether the warning dialog displays to back up files when the application starts.

    Log File Name

    Specifies the log filename in Single Log mode.

    Log Dir

    The destination directory to write the log files in multilog mode

    Reports Servlet Virtual Directory

    Specifies the name that has been defined for the virtual path used to define the Reports Servlet, which is used for running reports on the web. This setting is required when converting Run_Product calls to Run_Report_Object.

    Reports Servlet

    Specifies the name for the Reports Servlet used for running reports on the web. This setting is required when converting Run_Product calls to Run_Report_Object.

    Reports Server

    The name or IP address of the system running the Reports Server. This setting is required when converting Run_Product calls to Run_Report_Object.

    Default DESFORMAT

    Printer driver to be used when DESTYPE is PRINTER (XML, HTML, HTMLCSS, PDF, RTF, delimited).

    Default DESTYPE

    Type of destination device that receives the report output (cache, printer, file).

    Default DESNAME

    Name of the file, printer, e-mail ID, or distribution list to which the report output is sent

    Default Browser

    For UNIX, the browser used to display help for the Migration Assistant. This setting is either netscape or iexplore. In Windows, the system default browser is used.


  3. Click OK to save the configuration. The data is saved to the converter.properties file, and the settings you specify are used in the current and future sessions of the utility.

PK6v#{{PKc\EOEBPS/title.htm@ Oracle Forms Upgrading Oracle Forms 6i to Oracle Forms 11g 11g Release 1 (11.1.1)

Oracle® Forms

Upgrading Oracle Forms 6i to Oracle Forms 11g

11g Release 1 (11.1.1)

E10394-02

October 2009


Oracle Forms Upgrading Oracle Forms 6i to Oracle Forms 11g 11g Release 1 (11.1.1)

E10394-02

Copyright © 2009, Oracle and/or its affiliates. All rights reserved.

Contributors: Art Housinger, Phil Kuhn, Jan Carlin, Grant Ronald, James Amalraj, Laiju Mathew, Syed Nisar Ahmed

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this software or related documentation is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

This software is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications which may create a risk of personal injury. If you use this software in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the safe use of this software. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software in dangerous applications.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

This software and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.

PKcbuPKc\EOEBPS/preface.htm Preface

Preface

Welcome! This manual describes:

  • Features and functionality that have been removed from Forms Developer and Forms Services

  • Information about upgrade events that automatically occur when you open or deploy a Forms 6i application in Oracle Forms 11g.

  • Information about the Oracle Forms Migration Assistant, a tool to help you convert your applications.

  • Information about steps that developers, system administrators, and DBAs need to take to upgrade Forms applications from Forms 6i to Oracle Forms 11g.

Intended Audience

This manual is intended for developers, system administrators, and DBAs who develop and deploy Oracle Forms applications.

Documentation Accessibility

Our goal is to make Oracle products, services, and supporting documentation accessible to all users, including users that are disabled. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For more information, visit the Oracle Accessibility Program Web site at http://www.oracle.com/accessibility/.

Accessibility of Code Examples in Documentation

Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.

Accessibility of Links to External Web Sites in Documentation

This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.

Deaf/Hard of Hearing Access to Oracle Support Services

To reach Oracle Support Services, use a telecommunications relay service (TRS) to call Oracle Support at 1.800.223.1711. An Oracle Support Services engineer will handle technical issues and provide customer support according to the Oracle service request process. Information about TRS is available at http://www.fcc.gov/cgb/consumerfacts/trs.html, and a list of phone numbers is available at http://www.fcc.gov/cgb/dro/trsphonebk.html.

Related Documents

For more information, see the following manuals and online help:

In addition, you will find white papers and other resources at http://www.oracle.com/technology/products/forms/.

Conventions

The following text conventions are used in this document:

ConventionMeaning
boldfaceBoldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary.
italicItalic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.
monospaceMonospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.

PK>)PKc\EOEBPS/lovs.htmr List of Values (LOVs)

10 List of Values (LOVs)

In order to streamline the tools available and simplify the development process for building Forms applications for the Web, List of Values (LOVs) that are not applicable to Web deployment have been removed.

10.1 Obsolete List of Values (LOVs)

LOVs based on record groups are still valid. However, "Old-style" LOVs (V2.3-style LOVs) are obsolete in Oracle Forms.

When forms that contain old-style LOVs are upgraded to Forms Developer, the old-style LOVs' Old LOV Text property, which refers to a table and column (such as EMP.ENAME), is converted to a "new-style" LOV by creating a record group based on a query (select <column> from <table>). The new-style LOV is based on the new record group.

PK8lPKc\EOEBPS/items.htmY Item Types

8 Item Types

In order to streamline the tools available and simplify the development process for building Forms applications for the Web, item types that are not applicable to Web deployment have been removed.

8.1 Obsolete Item Types

The following item types are obsolete in Forms Developer and Forms Services.

Table 8-1 Obsolete Item Types

Item TypeUpgrade Notes

Chart Item

No upgrade path or replacement functionality.


8.2 Item Types Specific to Operating Systems

The following item types are specific to operating systems and are obsolete in Forms Developer and Forms Services. These items are not removed by the upgrade process. However, any modules that contain them do not compile. Use JavaBeans and Pluggable Java Components for equivalent functionality.

Table 8-2 Obsolete Item Types Specific to Operating Systems

Item TypeUpgrade Notes

VBX

Was applicable to 16-bit Windows platforms only. No upgrade path or replacement functionality.

OLE Container

Was applicable to Windows platforms only. Programmatic OLE interaction is supported with external OLE servers on the middle tier.

OCX/ActiveX Controls

Was applicable to Windows platforms only. JavaBean support provides similar functionality.

Sound

No upgrade path. JavaBeans provide equivalent functionality.


PKJ+PKc\EOEBPS/clientser.htmM Changes to Client/Server Deployment and Forms Runtime

7 Changes to Client/Server Deployment and Forms Runtime

This section contains the following:

7.1 Overview

Client/server runtime is obsolete in Forms Developer and Forms Services.

When you use Forms Developer, part of the upgrade process is to upgrade your Forms applications for Web-based deployment.

See Chapter 15, "Upgrading Client/Server Applications to the Web" for information about how client/server deployment differs from Web-based deployment.

7.2 Effect on Forms Development

The obsolescence of client/server deployment has little to no effect on the development and debugging of Forms applications. You can still run your code in Forms Developer without having to deploy on the Web first. Use the one-button-run facility, which renders a true WYSIWYG representation of a Web-deployed form.

The PL/SQL debugger has been improved to allow debugging in a three-tier environment.

7.3 Obsolete Forms Runtime Command Line Options

The following command line options for Runform have been removed because they relate to obsolete features:

  • OptimizeSQL

  • OptimizeTP

  • Keyin

  • Keyout

  • Output_file

  • Interactive

  • Block_menu

  • Statistics

7.4 Obsolete Character Mode Runtime

Character mode runtime, which was only available on UNIX and VMS platforms, is no longer available. All character mode support has been removed from Forms Developer and Forms Services. See Chapter 6, "Properties" and Chapter 9, "Logical and GUI Attributes" for more information.

PK=RMPKc\EOEBPS/cover.htm  Cover

Oracle Corporation

PK@t` PKc\EOEBPS/servlet.htm#V Upgrading Client/Server Applications to the Web

15 Upgrading Client/Server Applications to the Web

This chapter describes guidelines for upgrading client/server applications to the Web.

This chapter contains:

In addition, refer to the white papers and other resources at http://www.oracle.com/technology/products/forms/.

15.1 Guidelines for Upgrade

When upgrading your applications from client/server deployment to the Web, note that a Web-based application:

  • Supports JPEG and GIF image types only, so convert existing images to these formats.

  • Supports the use of compressed JAR (Java Archive) files for file transfer. Ensure you JAR the PJCs or Java beans for file transfer. You do not need to JAR files if transferring files from the client to the Forms server as part of the application functionality.

  • Does not support ActiveX, OCX, OLE, or VBX controls in the user interface. Instead, use JavaBeans to duplicate functionality in the user interface. Any other Microsoft Windows user interface dependencies should also be replaced with JavaBeans. You can also use WebUtil to restore some of these functions.

  • Does not support MouseMove triggers, such as When-Mouse-Enter, When-Mouse-Leave, and When-Mouse-Move.

  • Does not natively support write access to the client hard drive. This can be accomplished by the use of Oracle Forms Webutil library.

  • Supports Java fonts only, so check applications for the types of fonts used. If necessary, switch to Java fonts. Java uses a font alias list, located in the Registry.dat file. The font aliases described in Table 15-1 are supported:

    Table 15-1 Font Support for Web-based Applications

    Java fontWindows fontXWindows fontMacintosh font

    Courier

    Courier New

    adobe-courier

    Courier

    Dialog

    MS San Serif

    b&h-lucida

    Geneva

    DialogInput

    MS San Serif

    b&h-lucidatypewriter

    Geneva

    Helvetica

    Arial

    adobe-helvetica

    Helvetica

    Symbol

    Wingdings

    itc-zapfdingbats

    Symbol

    Times Roman

    Times New Roman

    adobe-times

    Times Roman


  • Has some Built-ins and packages that execute only in the application server, but not in the client browser:

    • TEXT_IO

    • HOST

    • ORA_FFI

    • GET_FILE_NAME

    • READ_IMAGE_FILE

    • WRITE_IMAGE_FILE

If the functionality of these Built-in and packages is required for the client, use WebUtil.

15.2 About Client/Server-Based Architecture

In the client/server-based implementation, shown in Figure 15-1, the Forms Server Runtime Engine and all application logic are installed on the user's desktop machine. All user interface and trigger processing occurs on the client, except for database-server-side triggers and logic that may be included in some applications.

Figure 15-1 Oracle Forms Client/Server Architecture

Legacy Forms Server client-server-based architecture

15.3 About Web-Based Architecture

In a Web-based implementation, shown in Figure 15-2, the Forms Services Runtime Engine and all application logic are installed on application servers, and not on client machines. All trigger processing occurs on the database and application servers, while user interface processing occurs on the Forms client, located on users' systems.

Figure 15-2 Oracle Forms Web Architecture

Web-based architecture overview
PK{Gb##PKc\EOEBPS/props.htm+ Properties

6 Properties

In order to streamline the tools available and simplify the development process for building Forms applications for the Web, properties that are not applicable to Web deployment have been removed.

6.1 Obsolete Properties

Many properties, including those associated with character mode and menus, have been removed. When you open a form that contains these properties, the properties are ignored and do not appear in Oracle Forms. Except as noted, code that attempts to use these properties at run time fails. Refer to Table 6-1, "Obsolete Properties" for more information.

Table 6-1 Obsolete Properties

Obsolete PropertyApplies toUpgrade Notes

Character Mode Logical Attribute

items, canvases, and so on.


Command Type

menu items

Note: This property is partially obsolete. The only valid values are Null, PL/SQL, and Menu.

If your menu module uses Plus, Form, or Macro, which are no longer valid values, the values are replaced by the following PL/SQL code in the Command Text property:

Plus: /* HOST('sqlplus <old_code>'); */ null;

Form: /* CALL_FORM(<old_code>); */ null;

Macro: /* MACRO: <old_code> ; */ null;

where <old_code> is the value of the Command Text property before upgrade. The replacement PL/SQL code is commented out so that you can replace the original code with new PL/SQL code.

Data Block Description

blocks


Fixed Length

items

Use a format mask with the relevant number of placeholders to limit or control the length of data entered for an item.

Help Description

menu items


Listed in Data Block Menu

blocks


List Type

LOVs

Because all LOVs are now based on record groups, this property is obsolete.

Menu Source

forms

A value of Database is no longer valid.

File is the only valid value for this property, which indicates that at run time, Forms uses the normal search path to locate the MMX file.

Runtime Compatibility Mode

forms

Ignored at runtime. 5.0 behavior is always used. (See the Forms Developer online help for a description of run-time behavior.)

To allow WHEN-VALIDATE-ITEM to run for NULL items, specify 4.5 for the DEFER_REQUIRED_ENFORCEMENT property.

(If your Forms application used "4.5" as the Runtime Compatibility Mode property setting, the Oracle Forms Migration Assistant automatically sets the Defer Required Enforcement property to "4.5".)

Trigger Style

triggers

All triggers are now PL/SQL triggers.

White on Black

items, canvases, and so on.



PKbY0+PKc\E OEBPS/toc.htm*, Table of Contents

Contents

Preface

1 Why Upgrade?

2 Using the Oracle Forms Migration Assistant

3 Converting Forms 6i FMTs to Oracle Forms FMBs

4 Built-ins, Packages, Constants, and Syntax

5 Triggers

6 Properties

7 Changes to Client/Server Deployment and Forms Runtime

8 Item Types

9 Logical and GUI Attributes

10 List of Values (LOVs)

11 User Exits

12 Menu Parameters

13 Java-Related Issues

14 Integration with Oracle Reports

15 Upgrading Client/Server Applications to the Web

16 Upgrading from Pre-Forms 6i Applications to Oracle Forms

Index

PKk 7**PKc\EOEBPS/trigs.htm" Triggers

5 Triggers

In order to streamline the tools available and simplify the development process for building Forms applications for the Web, triggers that are not applicable to Web deployment have been removed. In addition, the functionality of some triggers is being more strictly enforced.

5.1 Obsolete Triggers

Table 5-1 Obsolete Triggers

Obsolete TriggersUpgrade Notes

ON-DISPATCH-EVENT

Applies only to OLE and OCX items. Therefore, no upgrade path or replacement functionality.

All V2-style triggers

When you open FMBs that contain V2-style triggers, the triggers are dropped and a warning message lists the names of the dropped triggers. You should recode V2-style triggers into PL/SQL in Forms 6i, before upgrading to this release.

When-Mouse-Move/When-Mouse-Enter/When-Mouse-Leave Triggers

These triggers are ignored when running on the Web due to the amount of network traffic that would be generated.


5.2 Stricter Enforcement of Triggers

The use of the following triggers is more strictly enforced. These triggers do not execute if they are used incorrectly.

Table 5-2 Triggers with Restricted Usage

TriggerRestricted Usage

WHEN-CLEAR-BLOCK

WHEN-CREATE-RECORD

WHEN-DATABASE-RECORD

WHEN-NEW-RECORD-INSTANCE

WHEN-REMOVE-RECORD

Allowed at the Block and Form level only. No longer allowed at the Item level.

WHEN-NEW-FORM-INSTANCE

Allowed at the Form level only. No longer allowed at the Block and Item level.


PKfk'"PKc\EOEBPS/java.htm Java-Related Issues

13 Java-Related Issues

This chapter describes upgrade steps to take if your Forms applications use Java-related components.

13.1 Using oracle.ewt Classes in Pluggable Java Components

Pluggable Java Components (PJCs) and JavaBeans use classes that are part of the oracle.ewt framework. The sample PJCs and JavaBeans provided by Oracle are re-coded to use Swing classes or oracle.ewt classes. When upgrading to Oracle Forms, there are steps you must take to ensure equivalent functionality.

  • The Oracle Forms Jar files (frmall.jar and frmall_jinit.jar) contain only the EWT classes that are required by the Forms Java Client. Therefore, PJCs that had been used with Forms 6i may fail at runtime in Oracle Forms because the classes that were available in Forms 6i can no longer be located. Missing oracle.ewt classes are available in ewt.jar, which is supplied with Oracle JDeveloper.

  • Because of security constraints related to Java 1.3 and later (Oracle Forms 11g uses Java 1.6), you must re-sign all of the classes (including the Forms classes) with your own certificate. Java 1.3 requires that all classes from the same package be signed with the same certificate. Therefore, to use extra classes from ewt.jar in combination with frmall.jar, you must re-sign all of the classes with your own certificate.

13.2 JDK Versions and Font-Rendering Issues

When upgrading Forms applications from JDK 1.1 to JDK 1.3 or higher, you may encounter font height changes. This is because the code that renders fonts underwent significant changes from JDK 1.1 to JDK 1.3. As a result of these changes, the font height for logical fonts of the same size increased in JDK 1.3. For example, a dialog font of size 12 points has a height of 15 points in JDK 1.1 and a height of 17 points in JDK 1.3.

In Forms applications, the font size changes may affect labels, which can overlap text fields. One possible workrooms is to set the following applet parameter to "yes":

<PARAM NAME = "mapFonts" VALUE = "yes" >

After making this change, check the appearance of the font size to be sure it is acceptable. Modify the form if this workaround does not provide acceptable font sizes. See the Oracle Fusion Middleware Forms Services Deployment Guide for details.

Another workaround is that when the font is unspecified, the default font name and size in Registry.dat is used. The default font in registry.dat is Dialog with a default size of 900. The size of this font can be modified to a smaller value in the registry.dat file. In cases where the font is not specified, you can work around the problem without modifying the form. However, use caution because it modifies the font size for the entire application.

PK {"PK c\Eoa,mimetypePKc\E fa:iTunesMetadata.plistPKc\EYuMETA-INF/container.xmlPKc\EP?6:6 OEBPS/whymigr.htmPKc\El-OJ<OEBPS/dcommon/oracle.gifPKc\Ebww EOEBPS/dcommon/oracle-logo.jpgPKc\E0hOOEBPS/dcommon/cpyr.htmPKc\Er.hcSOEBPS/dcommon/blafdoc.cssPKc\Eo"nR M OEBPS/dcommon/doccd_epub.jsPKc\E'J OEBPS/toc.ncxPKc\Ew9@;OEBPS/content.opfPKc\ESTFF HOEBPS/las.htmPKc\EoJ44ZOEBPS/repgrph.htmPKc\E:dW] X pOEBPS/fmbfmt.htmPKc\Equ`_ OEBPS/index.htmPKc\ELHOEBPS/exits.htmPKc\EXa\OEBPS/params.htmPKc\EXbb#OEBPS/builtins.htmPKc\E1?|OEBPS/plsqlconv.htmPKc\Ewyck^kMOEBPS/img/formserv.gifPKc\EgVzzOEBPS/img/csimp.gifPKc\E6v#{{{OEBPS/migtool.htmPKc\EcbuOEBPS/title.htmPKc\E>) OEBPS/preface.htmPKc\E8l&'OEBPS/lovs.htmPKc\EJ+/OEBPS/items.htmPKc\E=RMDOEBPS/clientser.htmPKc\E@t` oUOEBPS/cover.htmPKc\E{Gb##WOEBPS/servlet.htmPKc\EbY0+{OEBPS/props.htmPKc\Ek 7** OEBPS/toc.htmPKc\Efk'")OEBPS/trigs.htmPKc\E {"OEBPS/java.htmPK!!2