Re: Problems saving forms to database.

From: Jacob Love <jlove_at_engin.umich.edu>
Date: 1995/10/07
Message-ID: <457346$aoa_at_srvr1.engin.umich.edu>#1/1


In article <44es1l$jto_at_watnews1.watson.ibm.com>, <mlanda_at_vnet.ibm.com> wrote:
>The database has to have certain tables created to save a
>Form in the database. Evidently, your DBA did not run the required scripts
>to create these tables or you do not have access. Have your DBA setup a Tools
>tablespace and then run the necessary scripts (connected as user system)
>to create the Oracle Tools database tables. The Forms scripts can be found in
>your Developer/2000 directory under \CDE2WIN\FORMS45\SQL (or whatever your
>directory structure is on your machine).
>
>The Forms Scripts include: (note: there is also a Windows ICON for these jobs)

[Deletia]

As an addendum to this, you might reconsider a decision to save Forms to the database. While there are some intrguing possibilities (and with Forms version 2 and 2.3 it was the preferred way to do things), Oracle is now shying away from this and encouraging people to regard their local and network file systems as the best way to handle Forms. The reason is three fold: 1) performance (in order to save to the database, Oracle has to break the form up into components which are saved to a set of tables and reassemble these components when a user requests the form), 2) version problems, and 3) bugs.

-- 
-----------------------
Jack F. Love
Opinions expressed are mine alone, unless you happen to agree
Received on Sat Oct 07 1995 - 00:00:00 CET

Original text of this message