Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PB Pipeline Oracle Long Varchar and Clob

Status
Not open for further replies.

ZManPB

Programmer
May 17, 2012
1
US
We're using PB 12.1 Classic. Pipe fails to pass data (no error message) in a Oracle column defined as Long Varchar or Clob when the length gets over 25,000 or so. It does not matter if the tables are both Oracle (11g) or one is in SA11 (column defined as Long). The data is clearly there in the source table. It never gets to the destination table.

Straight SQL Insert works, as does Update. File import (tab-delimited) works. Only when using the Pipeline (also, datawindow update) does it fail.

Any ideas? Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top