Convert Binary data to BLOB data

[Former Member]

Hi SAP Gurus,

I am fetching a file form DMS using FM 'SCMS_DOC_READ'.

The contents of the file are impoted in table CONTENT_BIN.

Structure of table:

----------------------------------------------------------------------------------------------------------------------------------------------------
LINE     SDOK_SDATX      RAW      1022      0      Line for binary document contents, length for upload

----------------------------------------------------------------------------------------------------------------------------------------------------

In this table I am getting multiple lines of data for a single file.

Now, My requirement is a follows,

I need store this data into an oracle table.
The multiple lines of the table to be converted to a single line of BLOB format.

Please suggest,

Thanks & Regards,

Pavan.

[Former Member]

any idea guys???

Thanks & Regards,

Pavan.

[kesavadas_thekkillath]

Hi,

Not sure if  I'm correct.

From this page I see that BLOB is nothing but the abap type xstring  ABAP Keyword Documentation

BLOB

Binary large object. Name for a database field of the RAWSTRING data type.

In such case, you can use SCMS_BINARY_TO_XSTRING passing multiple lines to parameter BINARY_TAB.

[Former Member]

Hi,

Note 500340 - FAQ: LOBS   "6. How can I display LOB information?"

also check this FM "SCMS_FTEXT_TO_STRING" .

Regard's

SMruti