Creating Oracle Text Index using NHibernate

Question

Hi all, I have been playing with NHibernate (especially Fluent NHibernate) for couple months. I really like it and appreciate people who contribute to those projects.

I am trying to create an Oracle Text Index using NHibernate, but I couldn't get this to work.

session.CreateSQLQuery("create index MYSCHEMA.NAME_TEXT_INDEX on MYSCHEMA.MYTABLE(ORACLETEXTSEARCH) indextype is ctxsys.context");

It seems that the index is never been created. Do you know if it is possible to do this? Or if I get it all wrong.

Thanks!