Re: execute SPL in 4gl

EXECUTE statement doesn't support INTO clause. Try use cursor: DECLARE cur CURSOR FOR procedure_state OPEN cur USING s_sorig,s_sdest,s_dow,s_sprod FETCH cur INTO tts jjdai07@my-dejanews.com wrote: > > Hi, > > Thanks in advance ! > My question is I create a Stored Procedure on online 5 . > this procedure need 4 input arguments and return 1 value . > In my 4gl , I prepared the statement and execute it , > but the c4gl told me error . > can you tell me why . > > My code : > > LET procedure_str = " EXECUTE PROCEDURE " , > " get_tts( ? , ? , ? , ? ) INTO ? " > PREPARE procedure_state FROM procedure_str > LET s_dow=WEEKDAY(s_sdtpu) > EXECUTE procedure_state USING s_sorig,s_sdest,s_dow,s_sprod INTO tts > > Compile Error is > LET procedure_str = " EXECUTE PROCEDURE " , > " get_tts( ? , ? , ? , ? ) INTO ? " > PREPARE procedure_state FROM procedure_str > LET s_dow=WEEKDAY(s_sdtpu) > EXECUTE procedure_state USING s_sorig,s_sdest,s_dow,s_sprod INTO tts > |_______________________________________________________________________^ > | > | A grammatical error has been found on line 310, character 73. > | The construct is not understandable in its context. > | See error number -4373. > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum