Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to Read/Extract BLOB field from Oracle Database to SAP PO 7.5 using Sender JDBC adapter.

former_member826252
Discoverer
0 Kudos
369

Hello Team,
Just now i have a similar Asynchronous scenario I've to read the Blob field in the ORACLE DB system and I send it to a server abap proxy via SAP PO 7.5.

Our scenario design would involve as below:
Oracle Database (Sender) to SAP ECC (Receiver) via PO 7.5.

To read the BLOB field from the JDBC (ORACLE Table) I would be using following Select statement. When I run the select statement we are getting exception as below.
Select statement: SELECT * FROM table name;

Exception from JDBC Sender Channel:
Database-level error reported by JDBC driver while executing statement 'SELECT * FROM Table Name; 'The JDBC driver returned the following error message: 'java.sql.SQLException: ORA-22992: cannot use LOB locators selected from remote tables.
Note: We are unable to read the Blob field data in the database itself
In the DB level also I am getting the same error.

Can you please any help me here to explain/provide the solution?

Thanks,
VINOD K.

0 REPLIES 0