Results 1 to 3 of 3

Thread: Ora-01460

  1. #1
    Join Date
    Jan 2003
    Posts
    2

    Unanswered: Ora-01460

    We have a column that is a "long" and when we try to insert more that 32KB into it the we get error ORA-01460 Unimplemented or Unreasonable conversion requested.

    Any idea's

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Ora-01460

    Originally posted by vehnetltd
    We have a column that is a "long" and when we try to insert more that 32KB into it the we get error ORA-01460 Unimplemented or Unreasonable conversion requested.

    Any idea's
    You can't insert more than 32KB into a LONG column without using Pro*C, ODBC or OCI. I haven't done that, though.
    LONGs are obsolete, really - new databases should use LOBs.

  3. #3
    Join Date
    Jan 2003
    Posts
    2
    Thank Tony for the quick reply!

    On other thing is..

    We have changed the long to a BLOB and when we try to use .NET and the .Net Oracle provider an error is thrown.

    I belive it is because we are doing something wrong. Do you have any ideas on how to use .NET with the .Net Oracle provider to insert more than 32KB into a column??

    Thanks

Posting Permissions

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