Query uses index in SQLPlus but not in PLSQL

Irritating problem here.

I have a query which, when I run in SQLPlus or worksheet or svrmgr or anywhere else, uses an index that matches the where clause. As soon as I put this query into a PLSql proc it doesn't use the index.

The only difference is when the query is executed from sqlplus etc, I hardcode the search predicates, but when in PLSql they are variables (same value though).
Have tried hints, no good.

Any ideas out there ?

Thanks,
NeilC. Received on Wed Jan 19 2000 - 08:10:57 CST