Help: store procedure

I'm calling a store procedure from my program 4gl, but happen an error: error 410 in the "open" of the "cursor". Calling the"store procedure" from the "dbaccess" run well. Some idea? thanks

apalonso@uncoma.edu.ar wrote: > I'm calling a store procedure from my program 4gl, but happen an error: error > 410 in the "open" of the "cursor". > Calling the"store procedure" from the "dbaccess" run well. > Some idea? -410 Prepare statement failed or was not executed. No idea until we see your code. Apparently, your statement failed to prepare the 'EXECUTE PROCEDURE' statement, but you did not heed the error. There may be other reasons, too. Which version of I4GL are you using? On which platform? And especially, exactly what syntax are you using? -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"

Hi, Heres some sample code for a stored proc called "split_term" main define strTerm char(10) define intTermY integer define intTermM integer define PolNum integer define strSQL char(200) let polNum = 3242068 let strSQL = "Execute procedure split_term(?)" prepare p_proc from strsql declare c_proc cursor for p_proc open c_proc using polNum foreach c_proc into strTerm, intTermY, intTermM end foreach display "Term in Years", intTermY display "Term Months", intTermM HTH Paul McLaughlin apalonso@uncoma.edu.ar wrote in message <91ods1$j0i$1@news.xmission.com>... > > > >I'm calling a store procedure from my program 4gl, but happen an error: error >410 in the "open" of the "cursor". >Calling the"store procedure" from the "dbaccess" run well. >Some idea? > >thanks >