3 Replies Latest reply: Jun 12, 2008 6:23 AM by 21205 RSS

    Reading CLOB value

    user483578
      Hi All,

      Am trying to read a CLOB value from the oracle table using PEGA tool. Inserting a CLOB value to Oracle table works fine but retrieving/reading from the table gives problems.

      As there is no CLOB property to set in PEGA tool what is the possible way to read this data from the SQL that i am using within the tool?

      Any body to help
      or does anyone know to which forum to ask from ?
        • 1. Re: Reading CLOB value
          21205
          I've never heard of PEGA, maybe they have a forum too...

          In the mean time, you can use SQL*Plus. SQLDeveloper, PL/SQL Developer, TOAD
          SQL> create table t
            2  (c clob)
            3  /

          Table created

          SQL> insert into t
            2  values ('this is some text')
            3  /

          1 row inserted

          SQL> commit;

          Commit complete

          SQL> select *
            2    from t
            3  /

          C
          --------------------------------------------------------------------------------
          this is some text
          • 2. Re: Reading CLOB value
            545555
            http://www.pega.com/

            "Build For change" your "Solutions For Business Agility", using a "servicing backbone" by "model-driven development" to enable "dynamically executing new solutions by eliminating coding" for "5 points customer retention gain" and "40% productivity boost"

            ...Which apparently seems to involve writing everything to the database as a big CLOB.
            • 3. Re: Reading CLOB value
              21205
              Too funny! you get the maximum score for the Buzzword Bingo!