sql 游标

我建了个存储过程 sp_CURSOR1
运行正确
当我在游标中使用sp_CURSOR1时
提示  对象名  'sp_CURSOR1' 无效。
怎么回事？ 游标对存储过程不行吗？
游标源码如下：
declare gao_ok scroll cursor
for
select * from sp_CURSOR1 order by sno
for read only
open gao_ok
declare @sno varchar(10),@sname varchar(10),@cname varchar(20),@rate varchar(10)
fetch next from gao_ok into @sno,@sname,@cname,@rate
while @@fetch_status=0
begin
  print @sno+'---'+@sname+'---'+@cname+'---'+@rate
  fetch next from gao_ok into @sno,@sname,@cname,@rate
end
close gao_ok
deallocate gao_ok

---

select * from sp_CURSOR1 order by sno


是SELECT * from 存储过程不行,,

要用

SQL code:
INSERT #T EXCE sp_CURSOR1

select * from #T order by sno

---

select * from sp_CURSOR1?

sp_CURSOR1应该是表名 或是视图呀?

---

引用

select * from sp_CURSOR1 order by sno


是SELECT * from 存储过程不行,,

要用

SQL codeINSERT #T EXCE sp_CURSOR1select*from #Torderby sno

怎么用？
codeINSERT #T EXCE sp_CURSOR1  这句加在哪里？
怎么说#T无效
{