Error creating cursor handle
388288Feb 20 2003 — edited Feb 21 2003I'm a developer who is new to Oracle. I have a SQL statement that looks like this (adjusted slightly to make it more generic):
DELETE FROM Super
WHERE SuperImpID IN (
SELECT s.SuperImpID FROM Import i, Super s
WHERE s.SuperImpID = i.RecordID
AND s.Code = '10'
AND i.MesgTxt = 'ABCD'
AND s.UserField = 'EFGH')
This SQL statement executes fine and deletes the desired record when run from SQL Plus Worksheet. However, when I run it through an ODBC or BDE driver I get a message saying "Error creating cursor handle".
Can anyone suggest a solution?
Thanks, Dave