How can I limit the NUMBER of rows returned?

Doing selects from Solaris middleware with ProC to an Oracle7 server. Returned tables are normally small & quick, but occasionally we get a query which returns way too many rows so that even the first fetch is greatly delayed. I'd be happy to take the first 100 rows quickly, and ignore the rest. Any suggestions?

                                                                   --Baird Smith