hi,
i have to create oracle-java source from
java program. my code is :
( In Java which create java source in oracle)
strQuery = "CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED
\"ASCOMPONENT\" AS ";
strQuery += "import javax.xml.parsers.DocumentBuilderFactory; ";
strQuery += "import javax.xml.parsers.DocumentBuilder; ";
strQuery += "import org.xml.sax.SAXException; ";
strQuery += "import org.xml.sax.SAXParseException; ";
strQuery += "import org.w3c.dom.Document; ";
strQuery += "import org.w3c.dom.*; ";
strQuery += "import java.io.*; ";
strQuery += "import oracle.jdbc.driver.*; ";
strQuery += "import java.sql.*; ";
strQuery += "public class ASComponent ";
strQuery += "\n ";
strQuery += "{ "; // error here.../
strQuery += "\n ";
strQuery += "public static void readXML(
String strXML,String
strTable) ";
strQuery += "\n ";
strQuery += "{ ";
strQuery += "\n ";
strQuery += " } ";
strQuery += "\n ";
strQuery += " } ";
strQuery += "\n ";
System.out.println("Query = " + strQuery[i]);
stmt.executeQuery(strQuery);
i am getting error :
java.sql.SQLException: Non supported SQL92 token at position: 377:
so, what is that error ?
i think when it is getting '{ ' it is giving error...?
how we can use token '{}' in
jdbc.
so, what is the error..?
please help me its urgent..
Thanks in advance...