Results 1 to 3 of 3

Thread: {d} and updates

  1. #1
    Join Date
    Apr 2006
    Posts
    3

    Unanswered: {d} and updates

    I'm rather new to the whole database scene, and somehow I've been put of a VERY strange database issue. I apologize if any of these are dumb questions.

    Does the expression {d} mean anything to anyone here? I have an application that generates and executes sql commands of the form:
    "UPDATE sometable SET somecolumn = 'somestring' WHERE id = somenumber".

    Whenever somestring contains a letter d as the first character in a string enclosed by curly braces, I get an oracle error with code: "E_FAIL(0x80004005)". No error message is available.

    This error occurs in two seperate programs connecting to the same database, so I doubt it's a problem with the code.

    Has anyone encountered this error code before? Or maybe knows something about why the string: {d} is hated by oracle?

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Well, my Oracle 10g doesn't hate it.
    Code:
    SQL> update dept set dname = '{d}whatever' where deptno = 10;
    
    1 row updated.
    
    SQL> select * from dept where deptno = 10;
    
        DEPTNO DNAME          LOC
    ---------- -------------- -------------
            10 {d}whatever    NEW YORK
    
    SQL>
    What is your database? Do those programs, maybe, call the same procedure/function which might cause the probleM?

    [EDIT]
    Metalink has something about "E_FAIL"; it says that bug #1623117 (Rowset::GetData call for 100 records after retrieving 1 record returns
    E_FAIL for forward only read only recordset) was fixed in Oracle 8.1.7.3.0

    Really, what is your Oracle database? Is it lower than 8.1.7.3.0?
    Last edited by Littlefoot; 05-11-06 at 18:04.

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >"E_FAIL(0x80004005)". No error message is available.
    This is NOT an Oracle error code!
    A quick Google search indicates it is .NET error
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •