This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFBB62.072D1F50
Content-Type: text/plain;
charset="iso-8859-1"
Oracle 7.3.4 goes into desupport the end of this year. I just upgraded from
7.2.3 to 7.3.4 before the end of the year to get back on a supported
platform and I would like to keep my database on a supported platform.
Last year we started working with IFS to implement their ERP to replace this
old application. A couple of weeks ago, everyone had enough of IFS and said
thanks, but no thanks. The functionality was not there. The support here
in the U.S. is inexperienced. And their Asia support is almost
non-existent. When we first start working with IFS, the plan was to be
completely moved over to the new application before 7.3.4 went off support,
so I was safe. Now that we have to start back at square -2 (they left us in
a hole with a new plant in Thailand). Now, there is no way we will get a
new system in for all our implementations for a couple of years.
We are still on Forms 3 because the group I transferred to last year bought
the code for and old ERP system called Avalon a few years back and modified
it to make end users temporarily happy and they did not keep it up with
technology. Now, I get to fight to keep at least the database supported
even if the application tools are not.
-----Original Message-----
From: Thomas L. Harleman [mailto:tharleman_at_iquest.net]
Sent: Thursday, May 11, 2000 1:26 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle 8 and Forms 3
Bruce,
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 <http://www.inoug.org> )
Pinnacle Solutions ( www.pinnacle-solutions.com
<http://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_001_01BFBB62.072D1F50
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Oracle 8 and Forms 3</TITLE>
<META content="MSHTML 5.00.2919.6307" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=985534315-11052000>Oracle
7.3.4 goes into desupport the end of this year. I just upgraded from 7.2.3
to 7.3.4 before the end of the year to get back on a supported platform and I
would like to keep my database on a supported platform.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=985534315-11052000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=985534315-11052000>Last
year we started working with IFS to implement their ERP to replace this old
application. A couple of weeks ago, everyone had enough of IFS and said
thanks, but no thanks. The functionality was not there. The support
here in the U.S. is inexperienced. And their Asia support is almost
non-existent. When we first start working with IFS, the plan was to be
completely moved over to the new application before 7.3.4 went off support, so I
was safe. Now that we have to start back at square -2 (they left us in a
hole with a new plant in Thailand). Now, there is no way we will get a new
system in for all our implementations for a couple of years.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=985534315-11052000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=985534315-11052000>We are
still on Forms 3 because the group I transferred to last year bought the code
for and old ERP system called Avalon a few years back and modified it to make
end users temporarily happy and they did not keep it up with technology.
Now, I get to fight to keep at least the database supported even if the
application tools are not.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=985534315-11052000></SPAN></FONT> </DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader><FONT face="Times New Roman"
size=2>-----Original Message-----<BR><B>From:</B> Thomas L. Harleman
[mailto:tharleman_at_iquest.net]<BR><B>Sent:</B> Thursday, May 11, 2000 1:26
AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RE:
Oracle 8 and Forms 3<BR><BR></DIV></FONT>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=870380506-10052000>Bruce,</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=870380506-10052000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=870380506-10052000>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).</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=870380506-10052000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=870380506-10052000>Not
to be argumentative, but only to prompt some serious
thought:</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=870380506-10052000>Why
does Kimball need to go to Oracle 8? </SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=870380506-10052000>If
Kimball sees the need to move to Oracle 8 then why are they still on Forms
3?</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=870380506-10052000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=870380506-10052000>Tom
Harleman</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=870380506-10052000>Indiana Oracle Users Group VP (<A
href="
http://www.inoug.org">www.inoug.org</A>)</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=870380506-10052000>Pinnacle Solutions (<A
href="
http://www.pinnacle-solutions.com">www.pinnacle-solutions.com</A>)</SPAN></FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> root_at_fatcity.com
[mailto:root_at_fatcity.com]<B>On Behalf Of </B>Bruce Page<BR><B>Sent:</B>
Tuesday, May 09, 2000 11:53 AM<BR><B>To:</B> Multiple recipients of list
ORACLE-L<BR><B>Subject:</B> Oracle 8 and Forms 3<BR><BR></DIV></FONT>
<P><FONT face=Arial size=2>Where can I find a paper or directions on how to
get a</FONT> <FONT face="Courier New" size=2>SQL*Forms, Version 3.0
application to run against an Oracle 8 database?</FONT></P><BR>
<P><FONT face=Arial size=2>Bruce Page</FONT> <BR><FONT face=Arial
size=2>Oracle DBA</FONT> <BR><FONT face=Arial size=2>Kimball
international</FONT> <BR><FONT face=Arial size=2>Jasper, In 47549</FONT>
Received on Thu May 11 2000 - 10:59:43 CDT
