开发者

How to implement OracleDbType.Array and OracleDbType.Object in NHibernate

开发者 https://www.devze.com 2023-03-02 21:25 出处:网络
I have successfully implementedSQLDbType.Structuredin SQL.But facing problem in OracleDbType.Array andOracleDbType.Object .Any sample code which shows how to implement it using Nhibernate.

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;
0

精彩评论

暂无评论...
验证码 换一张
取 消