WebDB: inserting data into table from a procedure
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