Re: ODBC & Hints

From: joel garry <>
Date: Tue, 21 Feb 2012 08:49:16 -0800 (PST)
Message-ID: <>

On Feb 21, 8:03 am, Daria Wieczorek <> wrote:
> Hi,
> are there any known issues re: passing hints (in this case LEADING) to
> the db server via odbc? My problem is that a query which runs OK via
> direct access (e.g. using the Golden32 tool) hangs when executed via
> odbc. Since the query uses the LEADING hint my suspicion is that the
> odbc "swallows" the hint, treating it as a comment.
> Database is, odbc is Oracle ODBC Driver, Release
> Of course it also could be that the *application* using the odbc is
> "swallowing" the hint, not the odbc itself.
> Any ideas?
> Daria

Look at what it is executing on the server. There are various ways to do that, you can drill into sessions with dbconsole or oem, you can trace the code, you can see sql in dba views. Do you have a dba you can work with? What access do you have to the db on the server.


-- is bogus.
Received on Tue Feb 21 2012 - 10:49:16 CST

Original text of this message