Open an Oracle table/view
To open an Oracle table/view from the File menu, select Open. Then, from the OpenFile dialog window, press the Choose Other button. Finally, from the Choose Other dialog window, select from the Driver edit box "Oracle" and submit as it is indicated a name for an Oracle table/view, a database connection name, a user name and finally a user password in the appropriate edit boxes. The name of the Oracle table/view can either be input manually in the appropriate edit box or choosen from the Layer List dialog window by pressing the Choose button of the Choose Other dialog window. If the name of the table/view is entered manually and the user is not the owner of the table/view, the name of the owner of the table/view must be entered first following by a period and then, the name of the table/view.
The database connection name, user name and user password can be declared and set with 3 different environment variables in the user's system. In order to be read by Geogateway, the environment variable names for the database connection name, user name and user password must be respectively defined as ORADATABASE, ORAUSER and ORAPSSWD. Once those variables set, the user will have only to submit an Oracle table/view name in the Choose Other dialog window.
Field Selection
In the process of opening an Oracle table/view, attributes of the Oracle table/view can be also chosen. If the All Fields checkbox of the Choose Other dialog window is checked, all attributes of the table/view will be automatically selected and consequently displayed and accessible from the application. However, if the checkmark is removed, the names of all attributes will be displayed in the list box of the Choose Other dialog window and only the one(s) chosen by the user from the list box will be displayed and accessible from the application.
However there are a few restrictions regarding field selection. If a field name is specified in the Table/View edit box of the Choose Other dialog window, as discussed below, this field will be loaded, displayed and accessible from the application even if that field has not been selected by the user from the list box. If the table/view contains more than one Spatial or GeoImage field and one of these field names has been specified in the Table/View edit box, only the specified one will be loaded into the application even if another Spatial or GeoImage field has been selected from the list box.
To visualize Oracle Spatial field
In order to visualize an Oracle Spatial field, an Oracle table/view containing a Spatial field must be opened. There are different ways to open such a table: 1 Manually enter manually in the table/view edit box of the Choose
Other dialog window the name of the table/view containing a Spatial field and press OK. This method of selection must be used only if the table/view contains only one Spatial field.2 Manually enter in the table/view edit box of the Choose Other dialog
window the name of the table/view followed by S= and the name of the
Spatial field and press OK.
e.g. scott.cities S=roads, where scott is the name of the owner
of the table/view, cities the name of the table/view and roads
the name of the Spatial field
This method of selection must be chosen if the table/view contains
more than one Spatial field.
3. From the Layer List dialog window, choose a table/view name followed
by S= and the name of the Spatial field and press OK.Following the table/view selection, Geogateway will automatically display in the map area the graphical contents of the table/view spatial field.
To visualize Oracle GeoImage field
In order to visualize an Oracle GeoImage field, an Oracle table/view containing a GeoImage field must be opened. There are different ways to open such a table: 1 Manually enter in the table/view edit box of the Choose Other
dialog window the name of the table/view containing a GeoImage field and press OK. This method of selection must be used only if the table/view contains only one GeoImage field.2. Manually enter in the table/view edit box of the Choose Other
dialog window the name of the table/view followed by G= and the name
of the GeoImage field and press OK.
e.g. scott.usimage G=images, where scott is the name of the owner,
usimage the name of the table/view and images the name of
the GeoImage field
This method of selection must be chosen if the table/view contains
more than one GeoImage field
3. From the Layer List dialog window, choose a table/view name followed
by G= and the name of the GeoImage field and press OK.Once opened, select from the Map Panel the layer name (table/view) containing the GeoImage field and then from the main tool bar press the View Attribute icon. From the View Attribute window, select the column containing the GeoImage field. This column is easily recognizable from the others since each column's cell contains a picture of a photo camera. Pick one of the selected column's cells and select from the contextual menu choice, the Add to Area item.
Another way to open a GeoImage is based on the selection of the GeoImage's footprint. Once an Oracle table/view loaded and the View Attribute window of the layer (table/view) opened, select one of the footprints (polygon representing the edge of the geoImage) in the map area. In order to choose a footprint, first select from the Map Panel the layer name, then from the main tool bar press the Arrow Selector and finally, with the mouse cursor, choose the desired footprint. Once selected, one of the View Attribute's records will be highlighted indicating to which GeoImage belongs the footprint. From the highlighted row, select the GeoImage field cell and from the contextual menu choice, the Add to Area item.
Longitude and Latitude fields
If the Oracle table/view contains fields called Lon and Lat or x and y, Geogateway will automatically assign metadata to the layer to indicate these fields are to be used for the point location.
Export a file from the disk to Oracle
To export a file from the disk to an Oracle database, choose from the File menu the Utility item and from the Utility menu, the Export item. From the Export dialog window, first press the Source File Select button and choose a file from the Open File dialog window. Second, press the Destination File Select button and from the Open File dialog window press the Choose Other button. From the Choose Other dialog window, select from the Driver edit box "Oracle" and submit as it is indicated a name for an Oracle table (to be created), a database connection name, a user name and finally a user password in the appropriate edit boxes. From the Output Format list box, pick the "ORA:Oracle" format, and from the Exportable Items View list box select the "VEC Segment" option and finally press the Select All, ADD and Export buttons.
As mentioned above, if the ORADATABASE, ORAUSER and ORAPSSWD environment variables have been declared and set, the user will have only to enter in the Destination File edit box an table name.