Solved

ASP and ORACLE BLOB question

Posted on 2004-04-06
6
168 Views
Last Modified: 2010-04-06
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
0
Comment
Question by:Preetexpexc
  • 3
6 Comments
 
LVL 7

Expert Comment

by:ramesh12
ID: 10770118
This kind of error usually occurs when you try to update duplicate records.

Finrst find in your table if you have duplicate records
0
 

Author Comment

by:Preetexpexc
ID: 10776921
Hi Ramesh,
0
 

Author Comment

by:Preetexpexc
ID: 10776963
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
 
0
 

Author Comment

by:Preetexpexc
ID: 10777226
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
0
 

Accepted Solution

by:
PashaMod earned 0 total points
ID: 11006929
PAQed, with points refunded (100)

PashaMod
Community Support Moderator
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
RSS feed not showing item time 3 19
Forbidden errors 5 125
Examples of Web API, REST web services and SOA 7 189
Windows Tool to Build Android and iOS App 3 55
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
SASS allows you to treat your CSS code in a more OOP way. Let's have a look on how you can structure your code in order for it to be easily maintained and reused.
Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…
The viewer will learn how to count occurrences of each item in an array.

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now