Jarek has released his sample provider for Oracle here.

In his post he talks about a few of the more notable challenges he had and how he got around them.

If you are writing an EF provider this is gold!