Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Accessing Oracle CLOB field

  1. #1
    Join Date
    Sep 2005
    Posts
    1,403

    Default Accessing Oracle CLOB field

    Hi ,


    I am facing problem while accessing CLOB fields using kettle .The sql is wrriten in an input table and this is the error I am getting while previewing the output



    "An error occurred executing SQL in part get metadata[img]/wiki/images/newpage.gif[/url]:



    SELECT tactivities.notes
    FROM tactivities



    For input string: "4294967295""

  2. #2
    Join Date
    Nov 1999
    Posts
    459

    Default RE: Accessing Oracle CLOB field

    Hi,


    I added a Change Request - <a class="footnote" name="ref-CodeBeamer- 1644">[# 1644]</a> Supporting Large Objects (LOBs).



    Thanx,
    Jens

  3. #3
    Join Date
    Nov 1999
    Posts
    9,729

    Default RE: Accessing Oracle CLOB field

    Hi,

    Please try one of the latest development kettle.jar versions.
    I believe reading CLOB fields is supported now.
    There was a bug in the code that prevented reading the meta-data of large text fields correctly.

    Thanks,
    Matt

  4. #4
    Join Date
    Sep 2005
    Posts
    1,403

    Default RE: Accessing Oracle CLOB field

    Thanks a ton for the fast response, I really appreciate it.
    The fix is working fine !

    Cheers
    Sree

  5. #5
    Join Date
    Sep 2005
    Posts
    1,403

    Default RE: Accessing Oracle CLOB field

    But your fix causes another problem as it seems...

    I have a repository within an Oracle8i database and one in an Oracle9i database. The one within the 8i works fine, but when I save a transformation into the 9i database and I reload it after a restart of Spoon, all my transfer steps are empty, no SQL statements etc. Also the transformation doesn&#39;t run from within the 9i database.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.