SPL and webdriver

hi there, I've got this strange behavior: I created a procedure: CREATE PROCEDURE pr_add_prod_ref (prod INT,comp INT,grp INT,lang INT,refer CHAR(20), size VARCHAR(30), weight FLOAT(1), cont FLOAT(1), color NVARCHAR(30)) DEFINE maxi INT; insert into pr_prod_item (prop_reference,prop_size,prop_weight,prop_cont,id_product,id_company,id_grp) values (refer,size,weight,cont,prod,comp,grp); IF color IS NOT NULL THEN select max(id_prod_item) INTO maxi from pr_prod_item; insert into pr_color (id_prod_item,id_product,id_language,id_company,id_grp,color_name) values(maxi,prod,lang,comp,grp,color); END IF END PROCEDURE; within SQL editor I execute: execute procedure pr_add_prod_ref(1,1,1,'33','4444','','','',null); and it works fine BUT, in a HTML page (using webdriver) the same SQL statement : <?MIVAR NAME=SQLCMD> execute procedure pr_add_prod_ref(1,1,1,'33','4444','','','',null);<?/MIVAR> <?MISQL SQL=$SQLCMD><?/MISQL> gives an 'Illegal SQL statement in stored procedure.' ??? how come? any idea? Olivier -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own