I'm using SQLite for unit testing a NHibernate enabled C# application. The application is usually using an Oracle database. After finally being able to use sequences in SQLite i ran into an new problem:
I have some sql queries that call a function inside a package. These packages only exist in the oracle database. A call looks like 'select pkg_name.function_name(arg1, arg2) from foo'. I tried to use my own SQLiteFunction to resolve 'pkg_name.function_name', but unfortunately it's not working. Apparently the period between package_name and function_name is the problem. If i remove it from the query and my SQLiteFunction, everthing is fine. As i don't see why this period should make a difference, i consider this as a bug.
Does anybody know a way around this? I could also take patching the data provider into account if anybody can point me to the right direction.