Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: how to trans blob type field from mysql to oracle?

  1. #1
    Join Date
    Dec 2015
    Posts
    4

    Exclamation how to trans blob type field from mysql to oracle?

    I use table input and table output ,but show "error ora-01461 ",why ?

  2. #2
    Join Date
    Aug 2015
    Posts
    313

    Default

    why i am not assuming issue with Data type and length mismatch in SOURCE and TARGET databases ?

  3. #3
    Join Date
    Dec 2015
    Posts
    4

    Default

    source :mysql datatype:blob (table input)
    target : oracle datatype :longblob (table output)
    show error: error updating batch ORA-01461
    : can bind a LONG value only for insert into a LONG column .
    how to resolve it? thanks

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.