From: E@E.COM (steve)
Newsgroups: comp.databases.oracle,comp.lang.java.programmer
Subject: java unable to get a cursor from oracle
Date: Thu, 13 Dec 2001 05:59:42 +0800
Organization: http://extra.newsguy.com
Lines: 28
Message-ID: <1f4cawi.wmc2xolytyngN%E@E.COM>
NNTP-Posting-Host: p-884.newsdawg.com
User-Agent: MacSOUP/2.4.6


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.