OIP-04116: Cursor not ready for I-O 1

[sap]

i am working with active server pages.whlie i can succesfully insert data to oracle database from asp page,i can't retrive it to display on asp page.the error i see in browser is " OIP-04116: Cursor not ready for I-O " .
how it can be overcome?

 

[carp]

I found this on MetaLink:
===========================================
OIP-4116 is caused whenever a dynaset operation is attempted on a what appears
to be a valid Dynaset to OO4O (ie. no errors have been encountered) -but- a
valid dynaset does not exist. This may be caused by one of the following:

1) The dynaset was created without a valid SELECT statement (eg. Using INSERT
INTO ... in a CreateDynaset statement). You must use the ExecuteSQL method of
the OraDatabase object (ie. OraDatabase.ExecuteSQL() ) to process non-select
SQL statements.

2) The SQL statement passed to CreateDynaset is NULL.

3) The DISTINCT clause was used in the the SELECT statement passed to the
CreateDynaset.

4) An error in binding contexts has been made. This is when the SQL is like
'select * from emp where ename = :ENAME' and :ENAME is a parameter in the
collection.
============================================

Perhaps your problem lies in here somewhere.