I am curious why you need a cursor here if the result set appears to be a single record. Looks strange to me though I don't work with Oracle.
--- On Sun 05/21, Hendry < [EMAIL PROTECTED] > wrote: [...] CREATE OR REPLACE PROCEDURE "ORDER_SEL_MAX" ( result_cursor IN OUT TYPES.cursor_type ) IS BEGIN OPEN result_cursor FOR SELECT MAX(id) as orderId FROM tbl_order; END; _______________________________________________ No banners. No pop-ups. No kidding. Make My Way your home on the Web - http://www.myway.com
