GEMINI Tools - KGS ORACLE PL/SQL Stored Procedures Download

This web page are instructions to download the ORACLE-PLSQL Directory that contains the ORACLE PL/SQL stored procedure packages needed for the GEMINI Tools web apps to access and download Kansas Geological Survey well data.

You will need ORACLE sqlplus installed on your PC to compile the ORACLE PL/SQL stored procedures on your pc. You will need to contace KGS Computer Services for help.

The ORACLE-PLSQL ORACLE PL/SQL stored procedures software is bundled by 2 methods as a ZIP file and as a JAR File. Both will create the ORACLE-PLSQL directory with all the ORACLE PL/SQL stored procedures source files.

Download ORACLE-PLSQL.zip to your PC ORACLE-PLSQL.zip, i.e. right mouse click the URL Link to the left and select "save as ..." and save it anywhere you like on your PC.
Unzip the file. The program files are located under a directory called 'ORACLE-PLSQL' so it is safe to unzip where ever you like.
Download ORACLE-PLSQL.jar to your PC ORACLE-PLSQL.jar, i.e. right mouse click the URL Link to the left and select "save as ..." and save it anywhere you like on your PC.
Extract the JAR file by the following command

C:\jdk1.7.0_25\bin\jar xf ORACLE-PLSQL.jar
The program files are located under a directory called 'ORACLE-PLSQL' so it is safe to extract the jar where ever you like.

Directory Structure of ORACLE-PLSQL

kgs_kid_pkg.sql	Generate the Next Unique KID
Well Data
kgs_well_headers_pkg.sql	Get Kansas Well Header Information
kgs_las_files_pkg.sql	Get Log ASCII Standard (LAS) version 2.0 File Information
kgs_las_curves_pkg.sql	Get LAS Curve Information
kgs_perfs_dst_pkg.sql	Get Well Perforation Data
kgs_well_tops_pkg.sql	Get Well Tops Data
ks_strat_pkg.sql	Get Kansas Stratigraphic Units
kgs_core_data_pkg.sql	Get Well Measured Core Data
kgs_core_images_pkg.sql	Get Core Image File Information
TRS2LL_pkg.sql	Convert Township-Range-Section to Elevation, Latitude and Longitude
Measured Sections
kgs_outcrop_loc_pkg.sql	Get Measured Section Location Information
kgs_outcrop_data_pkg.sql	Get Measured Section Data
Brine Sample Data
brine_data_pkg.sql	Get Brine Sample Data
Drill Stem Test (DST) Data
dst_well_headers_pkg.sql	Get DST Well Header Information
dst_search_pkg.sql	Search for DST Records for a specific Well
dst_test_pkg.sql	Get DST Test Data
Oil & Gas Production
production_info_pkg.sql	Get Production Header Information
production_pkg.sql	Get Production Data
Misc.
common_pkg.sql	Common Methods - Not Used, but referenced?
headers_pkg.sql	Get Well Headers - Not Used, but referenced?
kgs_regions_pkg.sql	Get Tops Regions Data - Not Used, but referenced?

Compile the ORACLE PLSQL Stored Procedure

To compile the stored procedure you must start a sqlplus session. You will need to log into the session as IQSTRAT/{password}@KGSPRD, you will need to retrieve the password from computer services. You then can compile the PL/SQL Stored Procedure Package, e.g. @C:\ORACLE-PLSQL\brine_data_pkg, which will compile the brine_data_pkg stored procedure package. This will load & compile the stored procedure package into KGS Oracle.

This download process is provided only for maintenance, if by chance the database tables are changed or columns within a database is changed, that would cause the stored procedure to fail.

Author: John R. Victorine jvictor@kgs.ku.edu

The URL for this page is http://www.kgs.ku.edu/stratigraphic/JAVA_SRC/ORACLE-PLSQL/download.html

GEMINI Tools KGS ORACLE PL/SQL Stored Procedures Download to your PC

Directory Structure of ORACLE-PLSQL

Compile the ORACLE PLSQL Stored Procedure

GEMINI Tools
KGS ORACLE PL/SQL Stored Procedures
Download to your PC