ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "rs" <rustyst...@myway.com>
Subject RE: [REPOST] Need Help with sqlmap + refcursor oracle
Date Mon, 22 May 2006 05:29:53 GMT


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 < hendry.hu@elasitas.com > 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



Mime
View raw message