View Single Post

   
  #3 (permalink)  
Old 02-27-2008, 11:28 AM
Tonkuma
 
Posts: n/a
Default Re: Problem with SET_ROUTINE_OPTS()

How about this?
------------------------------ Commands Entered
------------------------------
--#SET TERMINATOR !
CALL SET_ROUTINE_OPTS('ISOLATION RR')!
CREATE PROCEDURE TEST (OUT outVALUE INT)
LANGUAGE SQL
BEGIN
SET outVALUE = 1;
END!
------------------------------------------------------------------------------
CALL SET_ROUTINE_OPTS('ISOLATION RR')

Return Status = 0


CREATE PROCEDURE TEST (OUT outVALUE INT)
LANGUAGE SQL
BEGIN
SET outVALUE = 1;
END
DB20000I The SQL command completed successfully.

Reply With Quote