Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Unable to populate Oracle table with Oracle Bulk Loader

  1. #1
    Join Date
    Oct 2014
    Posts
    8

    Default Unable to populate Oracle table with Oracle Bulk Loader

    Hi,

    I am trying to populate oracle table with Oracle Bulk Loader step. The source is an SQL Server table and there is one varbinary/blob column
    that contains pdf document. Whenever I check the data stream using the Preview feature of the GUI I see the correct data, but when the data
    landed in data file it us somehow truncated and I can see very different data between the <startlob> and <endlob> tag.
    So wrong data bulk load into the Oracle table I use oracle 12.0.1 oracle client and PDI 7.1 on windows computer

    Any idea?

    Jozsef

  2. #2
    Join Date
    Oct 2014
    Posts
    8

    Default

    Hi

    I seems that nobody tested Oracle Data Loader with blob data.
    Realising again and again how under documented this product, this forum was my last hope :-(

  3. #3
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Why don't you spring for a support contract, and ask the company that supports it?
    Just because this forum (which is admittedly dying) doesn't have answers, doesn't mean that the tool won't do it.

    I can't answer you, as I don't have an Oracle DB.

  4. #4
    Join Date
    Oct 2014
    Posts
    8

    Default

    Quote Originally Posted by gutlez View Post
    Why don't you spring for a support contract, and ask the company that supports it?
    Just because this forum (which is admittedly dying) doesn't have answers, doesn't mean that the tool won't do it.

    I can't answer you, as I don't have an Oracle DB.

    Hi Gutlez

    Thank you for the information

    Jozsef

Tags for this Thread

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.