Thin driver exception problem

Hi,

I am using thin driver with Oracle 8i
Following code raises an exception.

    protected CallableStatement cstmt;
    protected ResultSet rs;

    cstmt ........
    rs ......

    cstmt.setString(1, "FirstParam");
    cstmt.registerOutParameter(2, OracleTypes.CURSOR);

    // Folowing line throws an exception:     rs = (ResultSet) cstmt.getObject(2);

oci8 driver works for the above scenario, no problems. When I switch to thin driver, it raises exception with following message:

        "java.sql.SQLException: ORA-00942: table or view does not exist"

Does anybody know what is the difference in oci8 driver and thin driver?

Does thin driver need some specific configuration other then different url?

Thanks,
Dushan Received on Thu Oct 21 1999 - 11:33:35 CDT