Tomasz, i'm sorry.
i always use ibexpert to manage my database and test my store procedure and sql. now i think i have found the reason of failing to inserting. just i execute the procedure again, and clear all the history in the "parameters history", it can work correctly. thank you again. --- In [email protected], Tomasz Tyrakowski <t.tyrakowski@...> wrote: > > Hi, > > At the first glance, it should work as expected. > If you run by hand > select fa, fb, fc from test2(param1,param2) > and it does return a data set, then I'd take a closer look at the params > you pass to test2 inside test1. Make sure they're really what you think > they are. > Also, if you altered test2 in the database after creating/altering > test1, alter test1 again to itself (all procedures depending on X should > be altered, that is, byte-compiled, every time X is altered). > If that doesn't help, send more details. > > regards > Tomasz > > On 2011-11-22 09:15, ibmcom2011 wrote: > > hi, all, > > > > in a store procedure, i try to insert into a table some records from an > > other store procedure, it seems like this: > > > > create procedure test1 > > as > > begin > > insert into table1(f1, f2, f3) > > select fa, fb, fc from test2(param1, param2); > > end > > > > test2 is a store procedure defined in the same database. it fetchs records > > from some tables and an other store procedure. > > > > but nothing have done without any error. if execute alone the store > > procedure test2, lots of records can be founded. > > > > why? > > > > thanks. > > > > > > > > > > > -- > __--==============================--__ > __--== Tomasz Tyrakowski ==--__ > __--== SOL-SYSTEM ==--__ > __--== http://www.sol-system.pl ==--__ > __--==============================--__ >
