topic Re: Convert Binary data to BLOB data in Application Development and Automation Discussions

Convert Binary data to BLOB data

Former Member — Sun, 10 Feb 2013 13:24:32 GMT

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.

Re: Convert Binary data to BLOB data

Former Member — Mon, 11 Feb 2013 11:11:37 GMT

any idea guys???

Thanks & Regards,

Pavan.

Re: Convert Binary data to BLOB data

kesavadas_thekkillath — Mon, 11 Feb 2013 11:56:02 GMT

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.

Re: Convert Binary data to BLOB data

Former Member — Mon, 11 Feb 2013 12:32:12 GMT

Hi,

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

also check this FM "SCMS_FTEXT_TO_STRING" .

Regard's

SMruti