Re: Thin driver exception problem

We are using 8.1.5 version.
Do you pass data from oracle type CURSOR to the result set in your code, because
it seems that there is the problem?

thanks,
Dushan

Karl Logan wrote:

> What version of thin driver are you using? We use 8.1.6, and it works
> perfectly.
>
> Karl.
> On Thu, 21 Oct 1999 16:33:35 GMT, Dushan Veljovic
> <dveljovic_at_derivion.com> wrote:
>
> >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
>
> -----------------------------------------------------------
> Pocketsoft,
Received on Thu Oct 21 1999 - 22:42:41 CEST