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 firebird-support@yahoogroups.com, 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 ==--__
> __--==============================--__
>