Package oracle.sql does not exist
807606Mar 5 2007 — edited Mar 5 2007Hi all,
I have a piece of code here which creates a table in oracle database dynamically by taking all column names, their column types and table name at runtime. When I compiling this code, I am getting the following error
"Package oracle.sql does not exist"
I don't how to why it is coming. If anyone knows please help me.
My Code
--------------------
import java.sql.*;
import oracle.sql.*;
//import oracle.jdbc.oracore.Util;
//import oracle.jdbc.*;
import java.sql.*;
import java.math.BigDecimal;
import java.util.*;
public class Database1
{
Connection conn=null;
Statement stmt=null;
public void insert(String[][] Indata,String Tabname,int m,int n1)
//public void insert(String Tabname)
{
Connection conn=null;
try
{
//DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
//Class.forName("oracle.jdbc.driver.OracleDriver");
//conn =DriverManager.getConnection ("jdbc:oracle://oci8:/@mohan","SCOTT","TIGER");
String username = "SCOTT";
String password ="TIGER";
String url="jdbc:odbc:mohan1";
//String url=
String driver="sun.jdbc.odbc.JdbcOdbcDriver";
Class.forName(driver);
conn=DriverManager.getConnection(url,"SCOTT","TIGER");
conn.setAutoCommit (false);
//conn =DriverManager.getConnection ("jdbc:oracle://oci8:/@mohan","SCOTT","TIGER");
//conn.setAutoCommit(false);
}
catch(Exception e)
{
System.out.println(e);
}
try
{
String s1=Tabname+"n";
String s=Tabname+"m";
String query="CREATE TYPE"+" "+s+" "+"AS VARRAY("+m+") OF VARCHAR2(40)";
// String query2="CREATE TYPE"+" "+s1+" "+"AS VARRAY("+n1+") OF"+" "+s;
stmt = conn.createStatement ();
stmt.execute(query);
// stmt.execute(query2);
String query1="CREATE TABLE"+" "+Tabname+"(clo1"+" "+s1+")";
stmt.execute(query1);
//stmt.execute ("CREATE TYPE"+s+"AS VARRAY(10) OF varchar2(100)");
//stmt.execute ("CREATE TABLE"+ Tabname (column1 pro_varray)");
}
catch(Exception e)
{
System.out.println(e);
}
try
{
stmt = conn.createStatement ();
String[] b;
int q=0;
int n=Indata[0].length;
b=new String[n];
for (int r=0;r<Indata.length;r++) {
for (int c=0;c<Indata[r].length;c++) {
//System.out.print(" " + Indata[r][c]);
b[q]=Indata[r][c];
q++;
for(int i=0;i<n;i++)
{
// System.out.println(b);
ArrayDescriptor desc = ArrayDescriptor.createDescriptor("s1", conn);
ARRAY newArray = new ARRAY(desc, conn, b);
PreparedStatement ps =
conn.prepareStatement ("insert into tabName values (?)");
((OraclePreparedStatement)ps).setARRAY (1, newArray);
ps.execute ();
}
}
}
}
catch(Exception e)
{
System.out.println(e);
}
}
}