See section 20.2.2 of
this tutorial[
^] from Oracle. It's in VB.NET but there are plenty of free conversion sites if you're not comfortable doing it yourself.
From what I can see you will have to use Oracle Lite, Compact doesn't support Oracle 10/11g