Re: WebDB: inserting data into table from a procedure

'For Information' ----------------- The Informix support just called me back. To execute such a procedure, an UNDOCUMENTED flag has to be passed with the URL: MIqry2pass=on It tells to the engine to execute the procedure in 2 passes, but I don't explain why the single fact to do an insert into a table goes into self-altering the table. So, the code to execute properly the damn thing should be <?MIVAR NAME=MIqry2pass>on<?/MIVAR> <?MISQL sql="execute procedure test();"> <?/MISQL> I don't explain either why this flag is not in The F...... Manual. I only hope that we won't find any more bad surprises with this product !! Renaud MARTIAL csii@iway.fr Renaud MARTIAL wrote: > > Hi, > > I got a little problem with the WebDatablade Module (v3.30) on IUS 9.12.UC6 > > When I try to execute a procedure within a MISQL bloc, and that this > procedure > inserts a row (or do an update) in a table, I got the message > 'Exception from Informix: XIX000:-675:Illegal SQL statement in stored > procedure. '. > > I have to say that: > - There is no trigger on this table > - The procedure is quite simple : > create procedure test() returning int; > update remtest set s = 'coucou les amis' ;> return 1; > end procedure; > > - The execute bloc is : > <?MISQL sql="execute procedure test();"> > <?/MISQL> > > When I remove the update, all is correct. > > (When I execute the statement using dbaccess, all is correct). > > Is there such a constraint with Web Datablade ? > Does anybody has any idea ?? > > Thanks > > Renaud MARTIAL > csii@iway.fr