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 ==--__ __--==============================--__
