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.