Dear All,

I have make a store procedure :

"SET TERM ##;
CREATE PROCEDURE MERGE_CONTENT (SRC INTEGER, DST INTEGER)
AS
BEGIN
UPDATE REF_MASTER SET CATEGORY_ID = :DST WHERE CONTENT_ID IN
(SELECT DISTINCT CONTENT_ID
FROM REF_MASTER WHERE CATEGORY_ID = :SRC AND CONTENT_ID NOT IN (
SELECT CONTENT_ID FROM REF_MASTER WHERE CATEGORY_ID = :DST)) AND
CATEGORY_ID = :SRC;
DELETE FROM M_CATEGORIES WHERE CATEGORY_ID = :SRC;
EXIT;
END ## "

Then how to return value if i call from java with
"preparedStatement.ExecuteUpdate()"

Are with this "EXIT;" statement, this store procedure will return value if
succes or not ?

Regards,

Diko