REPOST: Re: java unable to get a cursor from oracle
Date: Sun, 30 Dec 2001 07:52:23 +0800
Message-ID: <4$--$$-$-%%%$___-$_at_news.noc.cabal.int>
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.
- WAS CANCELLED BY =======: Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!newsfeed00.sul.t-online.de!t-online.de!newsfeed.freenet.de!news2.euro.net!uunet!ash.uu.net!sac.uu.net!lax.uu.net!news.navix.net!u.n.a.c.4.n.c.3.l.l.e.r From: E_at_E.COM (steve) Newsgroups: news.admin.censorship,alt.test,comp.lang.java.programmer Subject: cmsg cancel <1f57voi.sfd21j1bz3q9sN%E_at_E.COM> Control: cancel <1f57voi.sfd21j1bz3q9sN%E_at_E.COM> Date: Wed, 2 Jan 2002 05:17:50 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: <cancel.1f57voi.sfd21j1bz3q9sN%E_at_E.COM> NNTP-Posting-Host: 166.102.15.34 X-Trace: iac5.navix.net 1009949176 28325 166.102.15.34 (2 Jan 2002 05:26:16 GMT) X-Complaints-To: abuse_at_navix.net NNTP-Posting-Date: 2 Jan 2002 05:26:16 GMT X-No-Archive: yes Comment: Dude, where's my NewsAgent? Xref: news.uni-stuttgart.de control:40289344
autocancel Received on Sun Dec 30 2001 - 00:52:23 CET