Piecewise fetching using perl dbi

Discussion in 'Perl Misc' started by JonL, Feb 11, 2005.

  1. JonL

    JonL Guest

    We have some data in an Oracle database stored as a Long Raw.
    We can extract it using DBI, but only up to a certain length.
    Once we get above 20MB we start getting error messsages ora-1062 which
    comes out as
    01062, 00000, "unable to allocate memory for define buffer"
    // *Cause: Exceeded the maximum buffer size for current plaform
    // *Action: Use piecewise fetch with a smaller buffer size
    // *Action: Use a client application linked with V8 (or higher)
    libraries.60


    I've looked up piecwise fetching and inserting in various Oracle
    documents but I dont think DBI supports it. Any Ideas?
    JonL, Feb 11, 2005
    #1
    1. Advertising

  2. JonL

    Guest

    "JonL" <> wrote:
    > We have some data in an Oracle database stored as a Long Raw.
    > We can extract it using DBI, but only up to a certain length.
    > Once we get above 20MB we start getting error messsages ora-1062 which
    > comes out as
    > 01062, 00000, "unable to allocate memory for define buffer"
    > // *Cause: Exceeded the maximum buffer size for current plaform
    > // *Action: Use piecewise fetch with a smaller buffer size
    > // *Action: Use a client application linked with V8 (or higher)
    > libraries.60
    >
    > I've looked up piecwise fetching and inserting in various Oracle
    > documents but I dont think DBI supports it. Any Ideas?



    Maybe upgrade your client application linked with V8 or higher.

    Or switch from long raw to blob. I know I've gone bigger than 20MB using
    blobs.

    Or use the "substr" sql function to select only chunks of the data.

    Xho

    --
    -------------------- http://NewsReader.Com/ --------------------
    Usenet Newsgroup Service $9.95/Month 30GB
    , Feb 12, 2005
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. dilou

    piecewise function

    dilou, May 21, 2006, in forum: VHDL
    Replies:
    4
    Views:
    993
    Mark Norton
    May 30, 2006
  2. Will Ware
    Replies:
    0
    Views:
    439
    Will Ware
    Nov 21, 2005
  3. jitasi
    Replies:
    1
    Views:
    733
    Terry Reedy
    Mar 4, 2007
  4. Yaj Bhattacharya

    dealing with piecewise arrays

    Yaj Bhattacharya, Mar 17, 2009, in forum: Ruby
    Replies:
    0
    Views:
    102
    Yaj Bhattacharya
    Mar 17, 2009
  5. Dave Stallard

    Fetching SQL boolean values with Perl DBI?

    Dave Stallard, Mar 20, 2011, in forum: Perl Misc
    Replies:
    1
    Views:
    332
    Uri Guttman
    Mar 21, 2011
Loading...

Share This Page