Oracle Data Provider Error [ORA-01460: unimplemented or unreasonable conversion requested] RRS feed

  • Question

  • Hello, I'm using the Oracle net provider to execute a script like this:



    insert into A (blob1) values (:blob1);

    insert into B (clob1) values (:clob1);



    I'm defining the parameters as OracleParameters with OracleTypes blob and clob respectivelly...


    When the size of both lobs is 30k the insert works ok, but when the size is 45k (or bigger) it fails with the error ORA-01460...


    Also if I execute each insert independently they work with sizes up to 100k or more...


    The script is executed by an OracleDataAdapter with the Update() method, and the parameters are using the default row values to apply...


    Could someone help me with this problem or propose a workaround???


    Thanks, M


    Wednesday, June 11, 2008 9:36 PM


All replies