Attention: We are retiring the ASP.NET Community Blogs. Learn more >

Strange Oracle Error...

Has anybody ever come across this error when trying to insert data into a CLOB column in Oracle using ADO?

Error Number :  -2147467259
Description  :  ROW-00060: Internal error: [daputchunk,2]

I've looked high and low in every spot on the web I can think of and haven't turned up any answers yet. What I'm doing is grabbing an entire section of text from an ini file using the Windows GetPrivateProfileSection API and then later on inserting that data into an Oracle CLOB column. Sometimes is succeeds and sometimes it fails with this error being returned.

4 Comments

  • I do remember seeing that error many times, but not recently.

    If I remember correctly, it was a general SQL syntax error. In my case, I think that either I tried to to an INSERT and one of my column definitions was set to "NOT NULL" and the value I was trying to insert into that column was null.

    Another time, I think I tried to insert a value that did not match the column definition in the table -- you know "bit" vs. "int" or something similar.

    But I remember being frustrated with the generic nature of the error message.

  • Try inserting data into the CLOB that is smaller than the one you are failing on.

    If that works then you have the same problem I had a while back.



    Afraid the news isn't good though.

    I bet you dollars to donuts that it is choking on it because the driver can't handle the large size.



    The ADO Driver will only let you send a subset of the size that oracle can handle.



    I ran into this before.

  • I had this same error; ASP + ADO does not allow other result fillings after a CLOB.

    This won't work

    resultSet.fields("someOtherField1").value = "foo"
    resultSet.fields("someCLOBField").appendChunk("bar")
    resultSet.fields("someOtherField2").value = "foo"

    But this will work

    resultSet.fields("someOtherField").value = "foo"
    resultSet.fields("someCLOBField1").appendChunk("bar")
    resultSet.fields("someCLOBField2").appendChunk("bar")

    Not the exact same problem, but usefull for other people who look at this thread.

  • Thanks, Ruben.

    Your solution fixed my problem as well.

Comments have been disabled for this content.