I have a query where I am calling from a table and from a cursor. When my program gets to this line, I get the error "CONFLIST must be created with SELECT .... INTO TABLE." As you probably have guessed conflist is the cursor. I don't want to make conflist a table. The funny thing about this is that this line is called for another function and it works fine. I don't get it. I have never had a problem doing a query from a cursor before. Here is the query.

SELECT O.* FROM conflist L, conford O INTO CURSOR tempord ;
WHERE L.O_rec_id = O.O_rec_id

Any help would be appreciated.

Thanks