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

  • Thread starter Thread starter vedavyas.rao
  • Start date Start date
V

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
 
Did you make sure your Connection object was Opened. Also run the stored
procedure from your database and make sure it works there first.
 
Back
Top