Does RDBMS Gateway support Oracle BLOB datatype ?

Tony_Yip · March 3, 2004, 2:29pm

Hello,

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

Any idea is welcome.

Jon_Sleep · March 3, 2004, 5:32pm

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

Tony_Yip · March 4, 2004, 8:03am

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

Jason · March 4, 2004, 11:35pm

Yes Tony, you are correct.

Jason

Tony_Yip · March 5, 2004, 9:30am

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

Jason · March 10, 2004, 6:01pm

Hi Tony,

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

Jason