When calling Oracle stored procedure with Custom Type as parameter , NHibernate is throwing exception. where as with MS SQL Server 2008 it is working.

Please check the attached Exception while calling Oracle Stored Procedure .

Class which implement IType

Type defined in Oracle

create or replace
TYPE employeeType AS OBJECT (employeeId INT, employeeName VARCHAR2 (50));
***************
create or replace
TYPE TESTTYPE AS TABLE OF EMPLOYEETYPE;

Stored Procedure

create or replace PROCEDURE TESTCUSTOMEMPLOYEE (PARAM1 OUT SYS_REFCURSOR,PARAM IN TESTTYPE) IS
BEGIN
open PARAM1 for SELECT EMP_ID,EMP_NAME,EMP_PASSWORD,TEAM_ASSOCIATED_WITH,IS_CAPTAIN,NO_OF_MOM,BALANCE FROM employee;
END;