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

RE: How 2 create table and seect records using stored procedure and ca by JCauble

JCauble
Mon Jan 09 09:51:04 CST 2006

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

"vedavyas.rao@gmail.com" wrote:

> 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
>
>