Oracle Database Discussions

Hi.

I want to connect a foxpro database using Oracle Database Gateway ODBC. But I have read in a white paper
that it has some limitations

• BLOB/CLOB data cannot be read through pass-through queries.
• Updates or deletes that include unsupported functions within a WHERE clause are not allowed.
• Stored procedures are not supported.
• Cannot participate in distributed transactions—they support single-site

The last two limitations make me wonder if I should give it a try.
-Does it mean that I cannot use PL/SQL to acces the foxpro data and I can only acces with "simple" sql?

-Could I have a incoherent data or data lose if a transaction fails?

-Anyone that has used Oracle Database Gateway for ODBC to acces a Foxpro Database could give me some advice?


Thanks in advance.
David.