Kbase 2811: How to set up and use the ORACLE gateway.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
How to set up and use the ORACLE gateway.
910625-gfs01
INTRODUCTION:
=============
This Product Services Technical Support Knowledgebase entry
describes how to install the PROGRESS ORACLE gateway to access
data in an an ORACLE database.
WHY YOU NEED TO DO THIS:
========================
To allow you to read and write data from and to an ORACLE database.
PROCEDURAL APPROACH:
====================
Steps to access the ORACLE database:
1. Make sure that the environment variable ORACLE_SID is
set properly for the ORACLE database you want to access.
2. Start an 'instance' for the ORACLE database.
3. Use 'prodb' to create a PROGRESS database from empty.db
to serve as the ORACLE database schema holder.
4. Create a PROGRESS executable that contains ORACLE support.
To accomplish this, you need to run 'probuild' and select
ORACLE support for your new executable. This generates a
link script that you must run for the system to create the
executable.
*** NOTE: *** Make sure the ORALIB environment variable
is set for your link script to complete properly.
5. Start a single-user client using the PROGRESS database
and new PROGRESS executable.
6. Select DATABASE from the Data Dictionary menu.
7. Select ORACLE UTILITIES from the Database menu.
8. Select CREATE ORACLE SCHEMA from the ORACLE UTILITIES
menu.
9. A prompt appears for the name of the ORACLE database.
Enter its name and press GO (F1 or CTL-X).
10. Enter the user/password to access the ORACLE database.
This user must have DBA privledges.
11. When you are connected to the ORACLE database, its
schema is read and the tables are displayed on the screen.
Select the table(s) you want to access via PROGRESS.
12. After you select the tables, their structures are read
and duplicated in the PROGRESS schema holder database.
13. You may now write PROGRESS procedures that access the
ORACLE database. Note that ORACLE does not have
an ARRAY datatype, so you cannot use database fields
with EXTENTS.
Connection Considerations:
Once you complete the procedure above, you do not need to
repeat it to access the ORACLE database. You can connect
the PROGRESS schema holder and the ORACLE database in one step.
For example, if the ORACLE database is named ORAODEMO and the
PROGRESS schema holder database is named ODEMO, you can start up a
session using the following command:
pro odemo -db oraodemo -dt oracle -ld oraodemo -U odemo -P
odemo
For VMS, create a parameter file with the above components
and use it to start PROGRESS:
PROGRESS odemo/PARMFILE=odemo.pf
ONLINE PROCEDURES OR UTILITIES:
===============================
sqldba (oracle)
probuild (PROGRESS)
REFERENCES TO WRITTEN DOCUMENTATION:
====================================
Database Gateways Guide (Chapters 2 & 3)
3GL Interface Guide (Chapter 1)
Progress Software Technical Support Note # 2811