on 11-30-2009 5:09 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.