Larry,

>If you didn't have access to the view (it's a view not a table), you would get a SQL error saying object didn't exist. It's possible there are no indexes for the given table or the WHERE clause doesn't have the correct criteria. Try using LIKE instead of = and see if there results are different.

>select * from user_indexes where upper(table_name) like 'MYTABLE%'

I created the following prg:

 nJDEHandle = SqlConnect (cJDEDataSource, cJDEUserId, cJDEPassword)

 SQLexec (nJDEHandle, "select * from user_indexes where upper(table_name) = 'F4211'", "CurOracle")
 
 SqlDisconnect (nJDEHandle)
 
 Select CurOracle
 Browse

When executed it browses an empty cursor (CurOracle). I tested with many other tables of that database and it allways returned an empty cursor (I made sure the tables I tested had indexes). I never got an error message returned by Oracle.

Fernando