Re: cannot call member function on object type

I'd have to go back to the manuals to
decide if this was expected, but you might try the following - even though it seems daft:

Add correlation variable:
>create index idx_test on test(col.d)

create index idx_test on test t (t.col.d)

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases


Peter Mutsaers wrote in message <87n0wv4gml.fsf_at_muon.mutsaers.com>...


>>> "Jonathan" == Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> writes:

>

>    Jonathan> This may not fix it, but in 8.1.5 a number of

>    Jonathan> problems disappeared if you used a 'correlation

>    Jonathan> variable', a.k.a. 'table alias'.

>

>Thanks, that solved it.

>

>Now, alas I found out that an index used on a part of an ADT is not

>used, which still makes ADT pretty useless in my case :(

>