Does RDBMS Gateway support Oracle BLOB datatype ?

,
1

Hello,

Does RDBMS Gateway support Oracle BLOB datatype ? If yes, how can it embedd the XML result back to Mediator Payload ? :confused:

Any idea is welcome.

2

Hi Tony

The EntireX XML Gateways for RDBMS (there are a few “gateways” out there, so just to be sure we are talking about the same thing) does not support BLOB’s. Implementing it has been discussed but nothing has been decided.

Jon

3

Hi Jon,

RDBMS Gateway does not support BLOB. So I have to use Gateway for Oracle DB instead.

According to documentation, Oracle BLOB data type is mapping to Byte of XML Gateway Data Type. Am I correct ?

Tony

4

Yes Tony, you are correct.

Jason

5

Hi Jason,

I have tried to use XML Gateway for Oracle to retrieve Oracle BLOB datetype. However, it returned error (see attached screen). Anything wrong ?

Tony

exception.gif
exception.gif800×600 20.2 KB

6

Hi Tony,

You’re seeing an error in the Wizard. This is fixed in the next patch,
7216.

Jason