RE: Oracle 8 and Forms 3

From: Thomas L. Harleman <tharleman_at_iquest.net>
Date: Wed, 10 May 2000 01:34:35 -0500
Message-Id: <10493.105308@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0000_01BFBA1F.E5F5B1A0 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Oracle 8 and Forms 3Bruce,

You're going to find that the version of PL/SQL in Forms 3.0 is significantly different than the version in Oracle 8. I was maintaining a Forms 3 against RDBMS 7.3.4 at a major pharmaceutical firm in Indianapolis up until last September. Obviously, you have forms written that you want to keep. But to do that, you'll want to EXPERIMENT with creating packages in Oracle 8 that generate exceptions that can be trapped in Forms 3 (lots of luck).

Not to be argumentative, but only to prompt some serious thought: Why does Kimball need to go to Oracle 8? If Kimball sees the need to move to Oracle 8 then why are they still on Forms 3?

Tom Harleman
Indiana Oracle Users Group VP (www.inoug.org) Pinnacle Solutions (www.pinnacle-solutions.com)

  -----Original Message-----
  From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Bruce Page   Sent: Tuesday, May 09, 2000 11:53 AM
  To: Multiple recipients of list ORACLE-L   Subject: Oracle 8 and Forms 3

Where can I find a paper or directions on how to get a SQL*Forms, Version 3.0 application to run against an Oracle 8 database?

  Bruce Page
  Oracle DBA
  Kimball international
  Jasper, In 47549

------=_NextPart_000_0000_01BFBA1F.E5F5B1A0 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Oracle 8 and Forms 3</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D870380506-10052000>Bruce,</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D870380506-10052000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D870380506-10052000>You're=20
going to find that the version of PL/SQL in Forms 3.0 is significantly = different=20
than the version in Oracle 8. I was maintaining a Forms 3 against RDBMS = 7.3.4 at=20
a major pharmaceutical firm in Indianapolis up until last September. = Obviously,=20
you have forms written that you want to keep. But to do that, you'll = want to=20
EXPERIMENT with creating packages in Oracle 8 that generate exceptions = that can=20
be trapped in Forms 3 (lots of luck).</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D870380506-10052000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D870380506-10052000>Not to=20
be argumentative, but only to prompt some serious = thought:</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D870380506-10052000>Why=20
does Kimball need to go to Oracle 8? </SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D870380506-10052000>If=20
Kimball sees the need to move to Oracle 8 then why are they still on = Forms=20
3?</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D870380506-10052000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D870380506-10052000>Tom=20
Harleman</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D870380506-10052000>Indiana Oracle Users Group VP (<A=20 href=3D"http://www.inoug.org">www.inoug.org</A>)</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D870380506-10052000>Pinnacle Solutions (<A=20 href=3D"http://www.pinnacle-solutions.com">www.pinnacle-solutions.com</A>= )</SPAN></FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
  <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT = face=3DTahoma=20
  size=3D2>-----Original Message-----<BR><B>From:</B> root_at_fatcity.com=20   [mailto:root_at_fatcity.com]<B>On Behalf Of </B>Bruce = Page<BR><B>Sent:</B>=20
  Tuesday, May 09, 2000 11:53 AM<BR><B>To:</B> Multiple recipients of = list=20
  ORACLE-L<BR><B>Subject:</B> Oracle 8 and Forms 3<BR><BR></DIV></FONT>   <P><FONT face=3DArial size=3D2>Where can I find a paper or directions = on how to=20
  get a</FONT> <FONT face=3D"Courier New" size=3D2>SQL*Forms, Version = 3.0=20
  application to run against an Oracle 8 database?</FONT></P><BR>   <P><FONT face=3DArial size=3D2>Bruce Page</FONT> <BR><FONT = face=3DArial=20
  size=3D2>Oracle DBA</FONT> <BR><FONT face=3DArial size=3D2>Kimball=20   international</FONT> <BR><FONT face=3DArial size=3D2>Jasper, In = Received on Wed May 10 2000 - 01:34:35 CDT