• Get Oracle stored procedure object output in NHibernate

    I’ve wasted view hours on this so I think I share in case you have a similar problem. We are working with Oracle Database and .NET project using NHibernate as a object-relation mapper. We have a function in Oracle that returns an Oracle Object. Objects in Oracle are user defined types. They are defined like this: CREATE OR REPLACE TYPE Foo as object( Value1 number, Value2 date, Value3 varchar(10) ); And now Oracle Function with signature like this: CREATE OR REPLACE FUNCTION Bar (id int) return Foo pipelined This function returns a Foo object and gets the id key from a table VT (some table). The 3 values from Foo…