DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Ora-24345

  1. #1
    Join Date
    Apr 2001
    Posts
    151
    Hi all,

    error Ora-24345: A Truncation or null fetch error occurred.

    Does anyone know how work around it?
    Elin@trend

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Increase your buffer size.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Apr 2001
    Posts
    151
    which buffer size????
    Elin@trend

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    What ever the application that is causing the error is running short of the buffer. So the solution is to increase the buffer size for the application that is running short of the buffer. Since I do not know what is the application that is causing this error, I cannot comment much on "which buffer to increase". Say for example that you are doing exp then you have to increase the size of buffer parameter that you pass along with the command. Similarly to sqlloader and etc. So find the application that is causing the error and increase the size.


    BTW: what is your OS, RDBMS versions. Are you trying to use OCI ?



    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Apr 2001
    Posts
    151
    Hi Sam

    >>your OS, RDBMS versions. Are you trying to use OCI ?

    NT 4.0, Oracle 8.0.5.2.1, yes

    One thing I was told that this ora- error only happend on the same machine. when user went to other machines to do the same thing (ERP user) and none identical error will be regenerated.
    Aren't those processes all being exec. in server side and nothing to do with client machine?


    Elin@trend

Posting Permissions

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


Click Here to Expand Forum to Full Width