>Got it Larry!
>
>>Who is the owner of the table in question?
>
>proddta
>
>>Try using All_Indexes. This is a view that has entries for all indexes that the current user has access to, not just the ones he owns.
>
>I tried with:
>

> SQLexec (nJDEHandle, "select * from all_indexes where trim (upper(table_name)) = 'F7611B'", "CurOracle")
>

>and it returned a cursor full of info (below is the display struct of CurOracle), but where do I find the names of the fields that make the index?
>

Fernando,
Join it with ALL_IND_COLUMNS (another view):

select a.index_name, b.* from all_indexes a, all_ind_columns b 
   where a.index_name = b.index_name and upper(a.table_name) = 'MYTABLE'

You may have to join the two views on table_name as well if you have indexes with the same name on multiple tables.

HTH.