How 2 create table and seect records using stored procedure and call it in asp

[vedavyas.rao]

I have a problem with stored procedure,
i created a stored procedure to create and select records like

create procedure s ......
begin
create tale s ( i declared al the variables)
insert into s(i inserted values)
select * from s;
end

and i called the procedure in my asp and it says

object cannot be used when it is closed;
please help me with this error
thank u
vyas

 

[Guest]

Did you make sure your Connection object was Opened. Also run the stored
procedure from your database and make sure it works there first.