RE: opaque_transform hint

From: ramick <ramick_at_dotster.com>
Date: Mon, 17 Apr 2006 13:26:15 -0700
Message-Id: <20060417202639.1E6842EDF09@turing.freelists.org>

An opaque datatype in Oracle is an abstract data type - see the SQLJ Dev guide and reference.

It states that XMLType is an example of an opaque type.

So, (guessing here) maybe an opaque_transform would change this datatype into something else?

Do you have an example of a query that demonstrates the hint in it's plan or a 10053 trace?

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Daniel Fink
Sent: Monday, April 17, 2006 8:50 AM
To: oracle-l_at_freelists.org
Subject: opaque_transform hint

I (and a colleague) have come across this undocumented hint several times recently and have no idea what it actually does. RTFM, Google, metalink, otn have nothing. Any ideas?

Regards,
Dan Fink

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Apr 17 2006 - 15:26:15 CDT