cancel
Showing results for 
Search instead for 
Did you mean: 

BLOB Compatibility in JDBC Receiver

Former Member
0 Kudos

Hi folks,

my requirement is to retreive BLOB Data from a Oracle Database using a JDBC Receiver.

This is my request message.

-

Exactly de same value that has the stringFiled.

¿Isn´t it posible to retrive this BLOB Data using a query_sql?

I´ve been reading and ¿is the execute procedure the only possible way to retrieve that BLOB data?

Thanks in advance.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Exactly de same value that has the stringFiled.

Have you tried SELECT option? I believe that should resolve this issue.

Follow this structure -

http://help.sap.com/saphelp_nwpi71/helpdata/EN/44/7b7171fde93673e10000000a114a6b/content.htm

Isn´t it posible to retrive this BLOB Data using a query_sql?

I´ve been reading and ¿is the execute procedure the only possible way to retrieve that BLOB data?

BLOB can be accessed using SELECT. I am not too sure about SQL_QUERY.

Regards,

Neetesh

Former Member
0 Kudos

Hi , Neetesh.

Yes I tried the select option, in that case my request was:

But BBDDVALUE has the value of the string field and no BLOB data retreiving.

In both cases, SELECT and SQL_QUERY if i asked for a string field the returning value is OK, but with a BLOB field the value of the response is the corresponding to the string field.

¿Sould I need mapping the BLOB value? or ¿ Is BLOB data only compatible with procedures?

Thanks.

Edited by: Mariluz CM on Dec 1, 2009 9:15 AM