[Fwd: DBD::Oracle and CLOB insert]

From: Lincoln A. Baxter (lab_at_lincolnbaxter.com)
Date: 12/23/04

  • Next message: Sam Vilain: "Bug in DBD::Pg 1.32 with bytea columns" 
    To: Dbi-Users <dbi-users@perl.org>
Date: Wed, 22 Dec 2004 18:10:31 -0500

    -------- Forwarded Message --------
    > From: Maldonado, Daniel CW2 CTARNG <daniel.maldonado@CT.NGB.ARMY.MIL>
    > To: lab@lincolnbaxter.com
    > Subject: DBD::Oracle and CLOB insert
    > Date: Wed, 22 Dec 2004 14:55:17 -0500
    > Why in the world is it so hard to find a good example on a CLOB field?
    > I searched google.groups, yahoo and nothing. Most people there had the same
    > questions I have and were unanswered.
    >
    > Hopefully someone on this list will be able to help.
    >
    > Is there a good example anywhere on how to insert data into a CLOB field?
    >
    > The data I am inserting is strictly text. I can not use a *varchar* because
    > I am going to exceed the limits of this type of datafield sooner or later.
     

    Look at t/30long.t. Most things are tested, one way or another, and long
    data types certainly are in that test.

    But more to the point: look at the POD (perldoc DBD::Oracle):

    The "Handling LOBSs" section would be a good place to start. Good doc
    there, with examples.

    There were no answers because the real answer was "RTFM".

    Lincoln

  • Next message: Sam Vilain: "Bug in DBD::Pg 1.32 with bytea columns"