JDeveloper 9.0.2, finder method does not work!!!

[pavelcoan]

I'm working whit JDeveloper 9.0.2, I'm programming an EJB, CMP from tables.

Now, in secction finders methods I got this query

SELECT * FROM CP WHERE WHERE ID_DEL = ?

and te function is

Collection findByDel( long id_del ) throws RemoteException, FinderException;

The finder method does not work, it returns all the records in the table

Does any one knows what is the correct query??