There is a bug in OrmLite.Oracle's paging sql generation, when there is no default ordering: OracleOrmLiteDialectProvider.GetColumnNames inserts an extra space between the select, and the first column.

Added Oracle test project, and moved the command line tests out to a different directory.

OracleSyntaxTests.cs contains failing tests.

For example, this original query:
  SELECT  Id, Foo, Bar, Baz, "COMMENT"
  FROM TestEntity

becomes this:

  SELECT * FROM (
  SELECT "_ss_ormlite_1_".*, ROWNUM RNUM FROM (
  SELECT  Id, Foo, Bar, Baz, "COMMENT"
  FROM TestEntity ORDER BY I) "_ss_ormlite_1_"   //ORDER BY "I", not by "Id" as it should be
  WHERE ROWNUM <= 10 + 100) "_ss_ormlite_2_" WHERE "_ss_ormlite_2_".RNUM > 10

and you get an OracleException : ORA-00904: "I": invalid identifier
Fix for the paging bug, just remove GetColumnNames override from OracleOrmLiteDialectProvider.cs
Failing test for issue #69

https://github.com/ServiceStack/ServiceStack.OrmLite/issues/69
Merge pull request #138 from AkosLukacs/master

Bug in Oracle paging SQL generation if there is no explicit ordering