?
Solved

oracle d2k - save forms,pl/sql in database

Posted on 2003-03-13
4
Medium Priority
?
2,633 Views
Last Modified: 2012-06-27
can any one tell me how to save oracle d2k forms, pl/sql libraries
into the database. Thanking u in advance.
0
Comment
Question by:sun_ora_hpt
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 22

Expert Comment

by:Helena Marková
ID: 8127194
I think that it is better to save form module in a file.

You can use the Access preference (ToolsPreferences Access tab) to change your Preferences file.

In the Module Access option, you can specify one of the following storage preferences for opening and saving modules:

File     Modules are loaded from and saved to the file system.
Database     Modules are loaded from and saved to the database.
Ask     Modules can be loaded from and saved to either the file system or the database.  Form Builder will prompt for the location of the file each time you perform these operations.

Module:  All

Default FILE

Henka
0
 

Author Comment

by:sun_ora_hpt
ID: 8133770
Thanks, Henka. I tried this way, I think this will get saved, but the problem is that it is giving error

PDE-PLI031  unable to fetch record from table TOOL_MODULE.

 I think to build the related tables, i tried to run the
develoer 2000 R2.0 admin / develoer 2000 build option,
It asks system passwd, Then it asks

 Enter Database Connection (e.g t:node:sid)[local] :

please tell me what parameter should i provide in the above ie t,node etc,
Thanking u in advance.
0
 
LVL 22

Accepted Solution

by:
Helena Marková earned 200 total points
ID: 8134459
It is the same as log in to SQL*Plus or Forms Developer (SID you can see in a file TNSNAMES.ORA).

This article from Metalink can help you:
How to Install Base Tables for Developer 2000 Tools

This document explains how to install base tables for Developer 2000 Tools (i.e. Oracle Forms  V4.5, Oracle Reports V2.5 and Oracle Graphics V2.5). Developer 2000 Tools allow saving modules to file system or database. To be able to save modules to the database, all bases tables must exist. If any of the base tables are missing or corrupt, usually ORA-00942 : "Table or view does not exist" or other errors will occur.

Types of Base Tables
There are a number of tables, views and synonyms which are shared by Oracle Forms, Oracle Reports and Oracle Graphics.  They have prefixes TOOLS, ROS, VG, GC or DE.  Base tables for Oracle Forms 4.5, Reports 2.5, and Graphics 2.5 have prefixes FRM45, SRW2, and GO respectively.
Check Common Base Tables, Views and Synonyms
Before you install the base tables, you need to find out if they exist already and thus skip the installation of existing objects. This process can be started from checking objects shared by all CDE products.Put the following code into a SQL*Plus script called checkobjects.sql.
set space 0
set escape off
set pagesize 100
column object_name format a30
column owner format a30
column object_type format a20
select object_name, owner, object_type from sys.dba_objects where object_name like 'TOOL\_%' escape '\' or object_name like 'ROS%'  or       object_name like 'VG\_%' escape '\' or object_name like 'GC\_%' escape '\' or object_name like 'DE\_%' escape '\' order by object_name, object_type;
Now log into SQL*Plus as SYSTEM (default password is MANAGER) and type:
SQL>start checkobjects.sql
You should see the following list of objects returned :  OBJECT_NAME                   OWNER                         OBJECT_TYPE ------------------------------------------------------------------------- DE_ATTACHED_LIBS              PUBLIC                        SYNONYM DE_ATTACHED_LIBS              SYSTEM                        VIEW DE_ATTACHED_LIBS_IDX          SYSTEM                        INDEX DE__ATTACHED__LIBS            SYSTEM                        TABLE GC_CHARTING                   PUBLIC                        SYNONYM GC_CHARTING                   SYSTEM                        VIEW GC_FIELD                      PUBLIC                        SYNONYM GC_FIELD                      SYSTEM                        VIEW GC_REFERENCE                  PUBLIC                        SYNONYM GC_REFERENCE                  SYSTEM                        VIEW GC__CHARTING                  SYSTEM                        TABLE GC__FIELD                     SYSTEM                        TABLE GC__REFERENCE                 SYSTEM                        TABLE ROSATTRIBS                    PUBLIC                        SYNONYM ROSATTRIBS                    SYSTEM                        VIEW ROSLFDESC                     PUBLIC                        SYNONYM ROSLFDESC                     SYSTEM                        TABLE ROSLFDESC_ID                  SYSTEM                        SEQUENCE ROSLFDESC_ID                  PUBLIC                        SYNONYM ROSOBJMAP                     PUBLIC                        SYNONYM ROSOBJMAP                     SYSTEM                        TABLE ROSSEQUENCES                  PUBLIC                        SYNONYM ROSSEQUENCES                  SYSTEM                        TABLE ROSSTRINGS                    PUBLIC                        SYNONYM ROSSTRINGS                    SYSTEM                        TABLE ROSSTRUCTS                    PUBLIC                        SYNONYM ROSSTRUCTS                    SYSTEM                        VIEW ROSTFDESC                     PUBLIC                        SYNONYM ROSTFDESC                     SYSTEM                        TABLE ROSTFDESC_ID                  SYSTEM                        SEQUENCE ROSTFDESC_ID                  PUBLIC                        SYNONYM TOOL_ACCESS                   PUBLIC                        SYNONYM TOOL_ACCESS                   SYSTEM                        VIEW TOOL_ACCESSIBLE               PUBLIC                        SYNONYM TOOL_ACCESSIBLE               SYSTEM                        VIEW TOOL_ACCESSIBLE_IDX           SYSTEM                        INDEX TOOL_ACCESS_IDX               SYSTEM                        INDEX TOOL_COMMENT                  PUBLIC                        SYNONYM TOOL_COMMENT                  SYSTEM                        VIEW TOOL_COMMENT_IDX              SYSTEM                        INDEX TOOL_DEPEND                   PUBLIC                        SYNONYM TOOL_DEPEND                   SYSTEM                        VIEW TOOL_DEPENDENT                PUBLIC                        SYNONYM TOOL_DEPENDENT                SYSTEM                        VIEW TOOL_LIBRARY                  PUBLIC                        SYNONYM TOOL_LIBRARY                  SYSTEM                        VIEW TOOL_LIBRARY_IDX              SYSTEM                        INDEX TOOL_LRAW                     PUBLIC                        SYNONYM TOOL_LRAW                     SYSTEM                        VIEW TOOL_LRAW_ID                  SYSTEM                        SEQUENCE TOOL_LRAW_ID                  PUBLIC                        SYNONYM TOOL_LRAW_IDX1                SYSTEM                        INDEX TOOL_LRAW_IDX2                SYSTEM                        INDEX TOOL_LTEXT                    PUBLIC                        SYNONYM TOOL_LTEXT                    SYSTEM                        VIEW TOOL_LTEXT_ID                 SYSTEM                        SEQUENCE TOOL_LTEXT_ID                 PUBLIC                        SYNONYM TOOL_LTEXT_IDX1               SYSTEM                        INDEX TOOL_LTEXT_IDX2               SYSTEM                        INDEX TOOL_MODID                    SYSTEM                        SEQUENCE TOOL_MODID                    PUBLIC                        SYNONYM TOOL_MODTYPE_IDX              SYSTEM                        INDEX TOOL_MODULE                   PUBLIC                        SYNONYM TOOL_MODULE                   SYSTEM                        VIEW TOOL_MODULE_IDX               SYSTEM                        INDEX TOOL_PLSQL                    PUBLIC                        SYNONYM TOOL_PLSQL                    SYSTEM                        VIEW TOOL_PLSQL_IDX                SYSTEM                        INDEX TOOL__ACCESS                  SYSTEM                        TABLE TOOL__COMMENT                 SYSTEM                        TABLE TOOL__DEPEND                  SYSTEM                        TABLE TOOL__LIBRARY                 SYSTEM                        TABLE TOOL__LRAW                    SYSTEM                        TABLE TOOL__LTEXT                   SYSTEM                        TABLE TOOL__MODULE                  SYSTEM                        TABLE TOOL__PLSQL                   SYSTEM                        TABLE VG_COLOR                      PUBLIC                        SYNONYM VG_COLOR                      SYSTEM                        VIEW VG_DRAWING                    PUBLIC                        SYNONYM VG_DRAWING                    SYSTEM                        VIEW VG_FONT                       PUBLIC                        SYNONYM VG_FONT                       SYSTEM                        VIEW VG_IMAGE                      PUBLIC                        SYNONYM VG_IMAGE                      SYSTEM                        VIEW VG__COLOR                     SYSTEM                        TABLE VG__DRAWING                   SYSTEM                        TABLE VG__FONT                      SYSTEM                        TABLE VG__IMAGE                     SYSTEM                        TABLE
88 rows selected.
Make sure all the objects listed above exist. The owner and type of the objects also have to be the same as above. If there is any discrepancy, you need to re-install those objects. Use SQL*Plus command DESCRIBE to check the structure of some of the tables. All the string data type must be VARCHAR2, otherwise re-installation of base objects is also needed.

Install / Re-install Common Base Tables
BEFORE YOU RUN ANY SCRIPTS, MAKE SURE YOU HAVE A BACKUP OF THE DATABASE AND SOURCE FILES FOR ALL APPLICATIONS (FMB AND MMB FILES FOR ORACLE FORMS; PLL FILES FOR PL/SQL LIBRARY; RDF AND SQL FILES FOR ORACLE REPORTS; OGD FILES FOR ORACLE GRAPHICS).
Since the common base tables are shared by different CDE Tools, dropping them may cause loss of data from other tools. The following scripts need to be run in order to build the base tables.  Log into SQL*Plus as SYSTEM to execute them and make sure the order in which they are specified as followed.  Note that when you run the "grant" scripts (the xxxgrnt.sql files), you will be prompted for a username. Specify a username if you want to grant access to one user at a time, or you can specify PUBLIC and every user will have access to the base tables.
On Microsoft Windows
The installation process creates a number of program groups which appear on your desktop.  The install and upgrade scripts can be run by double clicking the icons in the Developer 2000 Administration program group.  The actual scripts to install the common base tables for the Developer 2000 tools are in %ORACLE_HOME%\D2KDBTAB. The product specific script are located in %ORACLE_HOME%\D2KDBTAB\PRODUCT, where PRODUCT refers to product name eg. for Forms 4.5 the scripts are in %ORACLE_HOME%\D2KDBTAB\FORMS45 directory.  Note : %ORACLE_HOME% is the home directory for Oracle products i.e. where        Oracle products are installed.  The followings are scripts needed to be run to rebuild the base tables.
1. TOOLDROP.SQL         TOOLBILD.SQL            TOOLGRNT.SQL
2. ROSDROP.SQL          ROSBILD.SQL             ROSGRNT.SQL
3. VGDROP.SQL           VGBILD.SQL              VGGRNT.SQL 4. DEDROP.SQL           DEBILD.SQL              DEGRNT.SQL

Additionaly, you need (only for Oracle Graphics 2.5)
5. GCDROP.SQL           GCBILD.SQL              GCGRNT.SQL

Check Product Specific Base Tables
You are not required to install product-specific base tables for all CDE Tools. Any one of them can be installed independently. Log into SQL*Plus as SYSTEM and use the following SELECT statements to check the existence of the base tables first.
Oracle Forms
select object_name, owner, object_type from sys.dba_objects where object_name like 'FRM45%' order by object_name;
The above mentioned sql statement should give the following list:
FRM45_BINDVAR                 PUBLIC                        SYNONYM FRM45_BUFFER                  PUBLIC                        SYNONYM FRM45_ENABLED_ROLES           PUBLIC                        SYNONYM FRM45_GRP                     PUBLIC                        SYNONYM FRM45_OBJECT                  PUBLIC                        SYNONYM FRM45__BINDVAR                SYSTEM                        TABLE FRM45__BUFFER                 SYSTEM                        TABLE FRM45__GRP                    SYSTEM                        TABLE FRM45__OBJECT                 SYSTEM                        TABLE FRM45_ENABLED_ROLES           SYSTEM                        VIEW
10 rows selected.
Important: Please note that unlike Oracle Forms 4.0 which utilizes 62 base table objects, Oracle Forms 4.5 utilizes only the above 10 base table objects.  As a result, each of the above base table objects tend to be very large in size.
Oracle Reports
select object_name, owner, object_type from sys.dba_objects where object_name like 'SRW2%' order by object_type;
The above mentioned sql statement should give the following list:
SRW2_ANCHOR_IDX               SYSTEM                        INDEX SRW2_BODY_LOCATION_IDX        SYSTEM                        INDEX SRW2_BOILERPLATE_IDX          SYSTEM                        INDEX SRW2_COLUMN_IDX               SYSTEM                        INDEX SRW2_ELEMENT_IDX              SYSTEM                        INDEX SRW2_FRAME_IDX                SYSTEM                        INDEX SRW2_LAYOUT_GROUP_IDX         SYSTEM                        INDEX SRW2_LINK_IDX                 SYSTEM                        INDEX SRW2_MATRIX_IDX               SYSTEM                        INDEX SRW2_LISTS_IDX                SYSTEM                        INDEX SRW2_TEXT_SEGMENT_IDX         SYSTEM                        INDEX SRW2_QUERY_IDX                SYSTEM                        INDEX SRW2_PARAM_FORM_IDX           SYSTEM                        INDEX SRW2_OG_DOCUMENT_IDX          SYSTEM                        INDEX SRW2_OGD_COLUMN_MAP_IDX       SYSTEM                        INDEX SRW2_LAYOUT_IDX               SYSTEM                        INDEX SRW2_GROUP_IDX                SYSTEM                        INDEX SRW2_DISPLAY_TAG_IDX          SYSTEM                        INDEX SRW2_DATA_MODEL_IDX           SYSTEM                        INDEX SRW2_BUTTON_IDX               SYSTEM                        INDEX SRW2_FIELD_IDX                SYSTEM                        INDEX SRW2_ANCHOR                   PUBLIC                        SYNONYM SRW2_BODY_LOCATION            PUBLIC                        SYNONYM SRW2_BOILERPLATE              PUBLIC                        SYNONYM SRW2_BUTTON                   PUBLIC                        SYNONYM SRW2_COLUMN                   PUBLIC                        SYNONYM SRW2_DATA_MODEL               PUBLIC                        SYNONYM SRW2_DISPLAY_TAG              PUBLIC                        SYNONYM SRW2_ELEMENT                  PUBLIC                        SYNONYM SRW2_FIELD                    PUBLIC                        SYNONYM SRW2_FRAME                    PUBLIC                        SYNONYM SRW2_GROUP                    PUBLIC                        SYNONYM SRW2_LAYOUT                   PUBLIC                        SYNONYM SRW2_LAYOUT_GROUP             PUBLIC                        SYNONYM SRW2_LINK                     PUBLIC                        SYNONYM SRW2_LISTS                    PUBLIC                        SYNONYM SRW2_MATRIX                   PUBLIC                        SYNONYM SRW2_MODULE                   PUBLIC                        SYNONYM SRW2_OGD_COLUMN_MAP           PUBLIC                        SYNONYM SRW2_OG_DOCUMENT              PUBLIC                        SYNONYM SRW2_PARAM_FORM               PUBLIC                        SYNONYM SRW2_QUERY                    PUBLIC                        SYNONYM SRW2_TEXT_SEGMENT             PUBLIC                        SYNONYM SRW2__ANCHOR                  SYSTEM                        TABLE SRW2__DISPLAY_TAG             SYSTEM                        TABLE SRW2__DATA_MODEL              SYSTEM                        TABLE SRW2__TEXT_SEGMENT            SYSTEM                        TABLE SRW2__QUERY                   SYSTEM                        TABLE SRW2__PARAM_FORM              SYSTEM                        TABLE SRW2__OG_DOCUMENT             SYSTEM                        TABLE SRW2__OGD_COLUMN_MAP          SYSTEM                        TABLE SRW2__MATRIX                  SYSTEM                        TABLE SRW2__LISTS                   SYSTEM                        TABLE SRW2__LINK                    SYSTEM                        TABLE SRW2__LAYOUT_GROUP            SYSTEM                        TABLE SRW2__LAYOUT                  SYSTEM                        TABLE SRW2__GROUP                   SYSTEM                        TABLE SRW2__FRAME                   SYSTEM                        TABLE SRW2__FIELD                   SYSTEM                        TABLE SRW2__ELEMENT                 SYSTEM                        TABLE SRW2__BODY_LOCATION           SYSTEM                        TABLE SRW2__BOILERPLATE             SYSTEM                        TABLE SRW2__BUTTON                  SYSTEM                        TABLE SRW2__COLUMN                  SYSTEM                        TABLE SRW2_ANCHOR                   SYSTEM                        VIEW SRW2_FIELD                    SYSTEM                        VIEW SRW2_ELEMENT                  SYSTEM                        VIEW SRW2_OGD_COLUMN_MAP           SYSTEM                        VIEW SRW2_MODULE                   SYSTEM                        VIEW SRW2_MATRIX                   SYSTEM                        VIEW SRW2_LISTS                    SYSTEM                        VIEW SRW2_LINK                     SYSTEM                        VIEW SRW2_LAYOUT_GROUP             SYSTEM                        VIEW SRW2_LAYOUT                   SYSTEM                        VIEW SRW2_GROUP                    SYSTEM                        VIEW SRW2_TEXT_SEGMENT             SYSTEM                        VIEW SRW2_QUERY                    SYSTEM                        VIEW SRW2_PARAM_FORM               SYSTEM                        VIEW SRW2_OG_DOCUMENT              SYSTEM                        VIEW SRW2_FRAME                    SYSTEM                        VIEW SRW2_BOILERPLATE              SYSTEM                        VIEW SRW2_COLUMN                   SYSTEM                        VIEW SRW2_DATA_MODEL               SYSTEM                        VIEW SRW2_DISPLAY_TAG              SYSTEM                        VIEW SRW2_BUTTON                   SYSTEM                        VIEW SRW2_BODY_LOCATION            SYSTEM                        VIEW
86 rows selected.

Important: Please note that base table objects for Oracle Reports 2.5 and Oracle Reports 2.0 are one and the same.  
Oracle Graphics
select object_name, owner, object_type from sys.dba_objects where object_name like 'GO\_%' escape '\' order by object_type;
The above mentioned sql statement should give the following list:
GO_COLUMN                     PUBLIC                        SYNONYM GO_DOCUMENT                   PUBLIC                        SYNONYM GO_PARAMETER                  PUBLIC                        SYNONYM GO_QUERY                      PUBLIC                        SYNONYM GO_SOUND                      PUBLIC                        SYNONYM GO_TIMER                      PUBLIC                        SYNONYM GO_VISLAYER                   PUBLIC                        SYNONYM GO__COLUMN                    SYSTEM                        TABLE GO__PARAMETER                 SYSTEM                        TABLE GO__SOUND                     SYSTEM                        TABLE GO__TIMER                     SYSTEM                        TABLE GO__VISLAYER                  SYSTEM                        TABLE GO__QUERY                     SYSTEM                        TABLE GO__DOCUMENT                  SYSTEM                        TABLE GO_COLUMN                     SYSTEM                        VIEW GO_DOCUMENT                   SYSTEM                        VIEW GO_PARAMETER                  SYSTEM                        VIEW GO_QUERY                      SYSTEM                        VIEW GO_SOUND                      SYSTEM                        VIEW GO_TIMER                      SYSTEM                        VIEW GO_VISLAYER                   SYSTEM                        VIEW
21 rows selected.

Important:  Please note that the base table objects for Oracle Graphics 2.5 and Oracle Graphics 2.0 are one and the same.

Re-install Product Specific Base Tables
BEFORE YOU RUN ANY SCRIPTS, MAKE SURE YOU HAVE A BACKUP OF THE DATABASE AND SOURCE FILES FOR ALL APPLICATIONS (FMB AND MMB FILES FOR ORACLE FORMS; PLL FILES FOR PL/SQL LIBRARY; RDF AND SQL FILES FOR ORACLE REPORTS; OGD FILES FOR ORACLE GRAPHICS).
If any object of a CDE Tools application is missing or the string data type of any table is CHAR instead of VARCHAR2, you need to re-install the base objects.  Again, log into SQL*Plus as SYSTEM and execute the scripts.  You can grant access to individual user or PUBLIC when you run the "grant" scripts.

Oracle Forms 4.5: On Windows:
In %ORACLE_HOME%\D2KDBTAB\FORMS45  FRM45DRP.SQL            FRM45BLD.SQL            FRM45GRT.SQL

Oracle Reports 2.5: On Windows:
In %ORACLE_HOME%\D2KDBTAB\REPORT25
SRW2DROP.SQL            SRW2BILD.SQL            SRW2GRNT.SQL

Oracle Graphics 2.5: On Windows:
In %ORACLE_HOME%\D2KDBTAB\GRAPH25  GODROP.SQL              GOBILD.SQL              GOGRNT.SQL
0
 

Author Comment

by:sun_ora_hpt
ID: 8135348
Thanks, it worked out.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question