Home » SQL & PL/SQL » SQL & PL/SQL » ASP - Oracle Cursor not ready for I-O
ASP - Oracle Cursor not ready for I-O [message #2411] Fri, 12 July 2002 11:17 Go to next message
Narsi
Messages: 5
Registered: July 2002
Junior Member
Hi ,

I am connecting to Oracle from ASP pages using OO40 connectivity. I am doing an simple insert into a table and code goes thus

mySQL = "Insert into gets_gs_cd_dept(DEPT_NO,PROD_DESC1,PROD_DESC2,PROD_CODE) values(" & department

mySQL = mySQL & ",'" & description1 & "','" & description2 & "','" & prodCode & "')"

set rstemp=OraDatabase.dbCreateDynaset(mySQL,Cint(0))

I get an error

Oracle Automation error '800a01b8'

OIP-04116: Cursor not ready for I-O

Can anyone tell me where I am going wrong.

TIA
Narsi
Re: ASP - Oracle Cursor not ready for I-O [message #2412 is a reply to message #2411] Fri, 12 July 2002 11:32 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
i am not very sure about this.
i have been previously informed that oradatabase.createDynaset can be use only on SELECT statement.
For all DML, DDL u need to use OraDatabase.ExecuteSQL
Previous Topic: Re: module overloading
Next Topic: PLS-00382 when call a function in the same package
Goto Forum:
  


Current Time: Thu Mar 28 14:36:46 CDT 2024