Re: Webexplode() and SPLs

Taras! Try with this URL parameter in I'm sure that after that it will works! MIqry2pass=on example in our house: http://sun1.icos.si/usr/shop/webdriver?MIval=/sishop/index.html&MIqry2pass=o n (index.html page executing SPL which UPDATE something) Problem is that webdriver execute stored procedure like SELECT statement (and in SELECT statement INSERT and UPDATE is not allowed) Cheers, Matej Kovacic ICOS, Ljubljana - Slovenia mkovacic@icos.si Taras Kopach <tkopach@777.com.ua> wrote in article <34BDE834.4F105735@777.com.ua>... > Hi All. > Configuration : Informix Universal Server 9.12TC3, > WebBlade 3.30TC6 > > I've created a SPL routine with data modification statements (CREATE > TEMP TABLE, > INSERT, DROP,DELETE) . But I can't execute this routine from the > <MISQL> tag > because it raising exception -675(Illegal SQL statement in stored > procedure) > According Error Messages this error occurs when restricted statement > used in stored > procedure which called from a SELECT statement, such as: > SELECT col FROM tab WHERE testproc(tab.col, tab.key) = 10 . > As I know, SQL statements in the <MISQL> tag are executed by the > Webexplode()> function. This process looks like : > SELECT webexplode(...) FROM wbPages WHERE ... > Hence, when we call a routine from the <MISQL> tag, the routine is > called from > SELECT statement. But this mean that we can't use data modification > statements > within routines . Am I wrong? > There is no problem to execute INSERT or UPDATE directly from <MISQL>, > > so, why I can't substitute several INSERTs with a single "execute > procedure" ? > Is this technology restriction or I'm wrong somewhere ? > > Thanks for any hints. > Regards, > Taras. > > > >