But the procedure can create a cursor output parameter. That's about
as close as you can come, I think.
create procedure Make_Cursor (
create table ##T (i int)
insert into ##T values (12343)
drop procedure Make_Cursor
drop table ##T
What is it you are trying to do, anyway?
> a stored procedure. input parameters are scalar by nature.
> Rac v2.1 coming soon
> > Is it possible to insert values into a table data type and then use that
> > value to exec another proc:
> > ALTER procedure pass_to_proc
> > as
> > tr_cash_related_securities_crs
> > Server: Msg 137, Level 15, State 2, Procedure pass_to_func, Line 6
> > Thanks in advance.