Strange Error with Code

[danielso...@my-deja.com]

I am having a bizarre exception from Oracle through their thin driver
trying to do something relatively simple. I am executing a query and
getting:

java.sql.SQLException: ORA-01009: missing mandatory parameter

at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java)
at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java)
at oracle.jdbc.driver.OracleResultSet.next(OracleResultSet.java)
at JDBCTest.main(JDBCTest.java:22)

The query is somewhat complicated, but works fine when run through
SQLPlus. Anyone seen anything like this?

import java.sql.*;

public class JDBCTest {
public static void main (String args[]){
try{
String SQL =
"(SELECT card_media_id FROM card_media_catagory WHERE catagory_id IN
"+
"(SELECT catagory_id FROM catagory WHERE catagory_name =
'catagory_test')) " +
"INTERSECT " +
"(SELECT card_media_id FROM card_media WHERE media_type = 'gif')";

Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@db:1521:ORCL", "user1",
"password1");

Statement stmt = conn.createStatement();
ResultSet rslt = stmt.executeQuery(SQL);
System.out.println(rslt.next());

}catch (Exception e){
e.printStackTrace();
}
}

}

Sent via Deja.com http://www.deja.com/
Before you buy.