I have successfully implemented SQLDbType.Structured in SQL.But facing problem in OracleDbType.Array and OracleDbType.Object .Any sample code which shows how to implement it using Nhibernate.
Following are my Procedure,Type and Object of Type which is IN parameter开发者_运维百科 to my stored Procedure.
CREATE OR REPLACE TYPE employeeType AS OBJECT (employeeId INT, employeeName VARCHAR2 (50));
CREATE TYPE ttEmployeeType AS TABLE OF employeeType;
***********Procedure***************************
CREATE PROCEDURE testCustom (pLocation ttEmployeeType)
AS
BEGIN
INSERT INTO employee (emp_id, emp_name)
SELECT * FROM TABLE(pLocation);
END;
精彩评论