Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005
    Posts
    2

    Unanswered: Using sqlldr with BLOB data from Sybase?

    Good morning!

    I used BCP to extract data (3 columns - INT, INT, BLOB, 2 rows of data) from a Sybase database into a file. I've recreated the table in an Oracle database and am now trying to use sqlldr to insert all of the data, however I am receiving the following error in the sqlldr log:

    Record 1: Rejected - Error on table BLOBTEST, column "DOC_TX_DATA".
    Field in data file exceeds maximum length
    Record 2: Rejected - Error on table BLOBTEST, column "DOC_TX_DATA".
    Field in data file exceeds maximum length

    My control file:

    load data
    infile 'c:\text_data.out'
    into table blobtest
    fields terminated by '$'
    (SEQNCE_ID,
    DOC_ID,
    DOC_TX_DATA)

    How do I insert this type of BLOB data with sqlldr?

  2. #2
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    Quote Originally Posted by Reyes
    How do I insert this type of BLOB data with sqlldr?
    As far as I know this is only possible if you have each BLOB in a separate file and the value of the corresponding column contains the file name. If you have that, you can import LOB (CLOB & BLOB) content using the following syntax:
    Code:
    load data
    infile 'c:\text_data.out'
    into table blobtest
    fields terminated by '$'
    (
      SEQNCE_ID,
      DOC_ID,
      lob_file_name FILLER, 
      DOC_TX_DATA LOBFILE(lob_file_name) TERMINATED BY EOF
    )

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •