ASP - Oracle Cursor not ready for I-O [message #2411] |
Fri, 12 July 2002 11:17 |
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
|
|
|
|