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.



Reply via email to