Link to home
Start Free TrialLog in
Avatar of Preetexpexc
Preetexpexc

asked on

ASP and ORACLE BLOB question

I am getting an error

Error Type:
Microsoft Cursor Engine (0x80004005)
Key column information is insufficient or incorrect. Too many rows were affected by update.

In an ASP page,  on this line it is trying to assign a value to a variable from ORACLE database
and the datatype of column is BLOB.

Its urgent could anyone please reply.

Thanks
Avatar of ramesh12
ramesh12

This kind of error usually occurs when you try to update duplicate records.

Finrst find in your table if you have duplicate records
Avatar of Preetexpexc

ASKER

Hi Ramesh,
Hi Ramesh,
     I already tried that.
     Its just one row.
     like this
     strqry = select one, two from table where fields = ABC (this 'fields ' is Primary Key)
     objrs.open strQry, objConn, adOpenDynamic, adLockPessimistic, adCmdText
     then extract these two values in two variables.(one variable is NUMBER and two variable is   BLOB).ONE Number is incremented by 1 and BLOB is extracted to a variable and nothing else done
then

objRS.UPDATE ----- This is where I get the error

All Help would be appreciated.

Thanks
 
OK........ I found the answer all I had to do was select the primary_key of the table in select statement and it works.

Thanks doe everyone's help
ASKER CERTIFIED SOLUTION
Avatar of PashaMod
PashaMod

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial