Re: java unable to get a cursor from oracle

been told by oracle it is a bug in the java drivers. steve

steve <E_at_E.COM> wrote:

> Hi,
> I have the following situation.
>
> oracle 8.1.5, java 8.1.5 client drivers (odbc)
>
> I have a procedure on the server written in pl/sql and a java client
> that connects to the procedure and recives a cursor back.
>
>
> the server schemas are broken into 3.
>
> A is the connection schema and ONLY has Execute on B and create session.
> B holds a package , that has full rights on c
> C holds the data
>
> the procedure (in the package in B) opens a REF CURSOR and returns a
> select on some table.
>
> but When the Java connects to the procedure it returns "table or view
> not found"
> if I then give A "SELECT ANY TABLE" the package works.
>
> However If i debug the sql using SQL programmer, then the package
> returns the cursor (even without the "SELECT ANY TABLE" being given to
> A)
>
> I was under the impression that a procedure executed with AUTH DEFINER,
> unless you changed the package header.
Received on Sun Dec 30 2001 - 00:52:23 CET