keerthikannan v

• Jan 23rd, 2012

 

Following Step need to setup before executing the Conversion Script


Step 1: Logon to the Database server and connect to the database.

Step 2: Run the below query and it should return five records:

Code
span style="font-style: italic;">------------------------------


CATALOG


CATPROC


CATJAVA


JAVAVM


XML

Step 3: If it doesnt you need to install those base Oracle Packages.

Code
 

Step 4: Copy the attached jxl.jar file to $ORACLE_HOME/jdk location on the database server.

Step 5: Upload the jar file using the below command:

Code
 


                    cd $ORACLE_HOME/bin


  loadjava -v -u system -r /u01/oracle/product/10.2.0/jdk/jxl.jar


 

Step 6: Execute below grant permissions:

Code
 

Step 7: Compile the Java stored Procedure(gocsv) from sql prompt


place the ExcelFile.xls in /home/retek/apps_files/ path and execute the blow script

Code
span style="font-style: italic;">-- directory with perms 

The Script will generate the following csv file

ExcelFile.xls.csv