Re: OO4O / all_catalog problem ?

From: Richard Willemsen <rwillems_at_xs4all.nl>
Date: Wed, 27 May 1998 06:36:41 GMT
Message-ID: <356bb3de.2188569@192.168.0.1>

Hi Bill,

On Tue, 26 May 1998 17:47:40 -0700, Bill Dietrich <bill_dietrich_at_wayfarer.com> wrote:

>I have an application doing a query
>"select owner, table_name from dba_tables order by owner, table_name".
>Works fine both through Oracle Objects For OLE (OO4O) and in SQL*Plus,
>when logged in as a user who has "select any table" privilege. Takes
>about
>30 - 40 seconds to run (we have a slow server, and Oracle Apps is
>installed,
>so about 4000 tables).
>
>Then I realized it WON'T work for users who don't have "select any
>table" privilege.
>So I changed the query to
>"select owner, table_name from all_catalog
>where (table_type != 'SEQUENCE') order by owner, table_name".
>

I did the same except I used the all_tables view and I did NOT found any problems.

>This works fine through SQL*Plus (takes 30 - 40 seconds to run), but
>when
>run through OO4O, never returns (something else times out after 5
>minutes).
>I'm still logging on as the same user (who has "select any table"
>privilege) every time.
>
>Any idea what could be going on ?
>
>Thanks,
>
>Bill Dietrich
>bill_dietrich_at_wayfarer.com
>
>

grtnx,
Richard

---

Real programmers don't comment their code. It was hard to write, it should be hard to understand.

---

Richard Willemsen
http://www.xs4all.nl/~rwillems/ Received on Wed May 27 1998 - 01:36:41 CDT