Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error creating cursor handle

388288Feb 20 2003 — edited Feb 21 2003
I'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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 21 2003
Added on Feb 20 2003
3 comments
383 views