RE: SPL with WebBlade gives reserved words error -675

You need to use the variable/function called MyQry2Pass. There isn't much documentation on it - but there is some. Also you can do a search on the archives from this newsgroup. > All, > little wee problem with WebBlade... > > If I have a simple table > create table t(key integer);> > and a very simple function foo: > > create function foo(int i) > returning integer;> > insert into t(key) > values(i);> > return i; > end function; > > I can successfully call this from dbaccess or isql with > 'execute function', > directly from another SPL, even manually begin a transaction > and commit (as > does WebBlade), but...if it is called from WebBlade it dies > with a "-675: > Illeagal SQL statement in stored procedure." > > According to trace and other debugging, it is dying when it tries to > insert - something like a mutable statement I guess. Does > anyone know what > the WebBlade is doing that makes it die? If I can't get this > to work its > going to kill some nice packaging... > > TIA, > Andrew. > > ___________________________________________________________________________ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of Sema Group. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the Sema Group Helpdesk by telephone on +44 (0) 121 627 5600. ___________________________________________________________________________