hi, robert-

>i want to create a cursor from a table called 'customer'
>but i want to keep the index inside because i want to do search with it

right just index the cursor when you've done your select statement the index won't persist