CO2 I - ORACLE PL/SQL Stored Procedures Download

This web page are instructions to download the ORACLE-I-Files Directory that contains the ORACLE PL/SQL stored procedure packages needed for the CO₂ 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-I-Files ORACLE Files software is bundled by 2 methods as a ZIP file and as a JAR File. Both will create the ORACLE-I-Files directory with all the ORACLE PL/SQL stored procedures source files.

Download ORACLE-I-Files.zip to your PC ORACLE-I-Files.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-I-Files' so it is safe to unzip where ever you like.
Download ORACLE-I-Files.jar to your PC ORACLE-I-Files.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-I-Files.jar
The program files are located under a directory called 'ORACLE-I-Files' so it is safe to extract the jar where ever you like.

Directory Structure of ORACLE-I-Files

Insert Data This directory contains all the scripts that loads the CO₂ I Data

o	insert_doe_co2_las3_files.sql	Insert DOE CO₂ Log ASCII Standard (LAS) version 3.0 Files into the DOE CO₂ LAS 3.0 File Information & Profile Plot Image Database Table
o	insert_doe_co2_LAS3_files_final.sql	Insert DOE CO₂ Log ASCII Standard (LAS) version 3.0 Files into the DOE CO₂ LAS 3.0 File Information & Profile Plot Image Database Table
o	insert_doe_co2_tops.sql	Insert DOE CO₂ Well Tops into the DOE CO₂ Well Tops Database Table
o	insert_doe_co2_tops_T31S-R1W-Sec_28.sql	Insert DOE CO₂ Well Tops for Township 31S - Range 1W - Section 28 into the DOE CO₂ Well Tops Database Table
o	insert_doe_co2_tops-Wellington_KGS_2-32.sql	Insert DOE CO₂ Well Tops for Wellington KGS 2-32 Well into the DOE CO₂ Well Tops Database Table
o	insert_geo_report_georeport.sql	Insert DOE CO₂ Geologist Cuttings & Core Description File Informaiton into the DOE CO₂ Geologist Cutting & Core Description File Information Database Table

PL/SQL This directory contains all the stored procedures that will retrieve the data as XML (Extensible Markup Language) or Summary Web Pages for the CO₂ project
o	doe_co2_summary_pkg.sql	Generate the DOE CO₂ Summary Web Page PL/SQL Stored Procedure Package
o	doe_co2_summary_ascii_pkg.sql	Generate the DOE CO₂ Summary Comma Separated Values (CSV) Web Page PL/SQL Stored Procedure Package
o	iqstrat_doe_co2_wells_pkg.sql	Generate the DOE CO₂ Wells Extensible Markup Language (XML) PL/SQL Stored Procedure Package
o	iqstrat_doe_co2_tops_pkg.sql	Generate the DOE CO₂ Tops Extensible Markup Language (XML) PL/SQL Stored Procedure Package
o	kgs_summary_pkg.sql	Generate the KGS Summary List of Geologist Cuttings Reports Web Page PL/SQL Stored Procedure Package
o	production_doe_co2_wells_pkg.sql	Generate the Production DOE CO₂ Wells Extensible Markup Language (XML) PL/SQL Stored Procedure Package

SQL This directory contains all the SQL Scripts that will build the database tables for the CO₂ I Tables
o	db_create_doe_co2_files_table.sql	Create the DOE CO₂ Log ASCII Standard (LAS) version 3.0 File Information, Profile Plot - Portable Network Graphics (PNG) Image File Information & Profile Plot - Portable Document File (PDF) File Information Database Tables
o	db_create_doe_co2_tops_table.sql	Create the DOE CO₂ Well Tops Database Table
o	db_create_doe_co2_georeport_table.sql	Create the DOE CO₂ Geologist Cutting & Core Description File Information Database Table
o	db_create_doe_co2_core_csv_table.sql	Create the DOE CO₂ Core CSV File Information Database Table

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-I-Files\co2_pressure_catalog_pkg, which will compile the Pressure Catalog Summary Web Page stored procedure package. This will load & compile the stored procedure package into KGS Oracle Database.

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/PRS/Ozark/JAVA_SRC/ORACLE-I-Files/download.html

CO2 I Tools Database Scripts Download to your PC

Directory Structure of ORACLE-I-Files

Compile the ORACLE PLSQL Stored Procedure

CO2 I Tools
Database Scripts
Download to your PC