C# µ÷ÓÃOracle ´æ´¢¹ý³Ì·µ»ØÊý¾Ý¼¯ ʵÀý

1. ÔÚoracle Ï´´½¨±í
     t_user(
        ID varchar(20),
        Name varchar(20)
       )
 2.  Ìí¼ÓÊý¾Ý 
           '1' , 'ÕÅÈý'
           '2' , 'ÀîËÄ'
 3. ´´½¨°ü²¢ÇÒ¶¨Òå±äÁ¿ºÍÉùÃ÷´æ´¢¹ý³Ì
     CREATE OR REPLACE PACKAGE pkg_user AS
        --¶¨Òå·µ»ØÖµ£¨ÓαêÀàÐÍ£©
      TYPE myrctype IS REF CURSOR;
         --¶¨Òå²éѯ¹ý³Ì
      PROCEDURE sp_userlist (cur_result OUT myrctype);
      END pkg_user;
 4.´´½¨´æ´¢¹ý³Ì sp_userlist
     CREATE OR REPLACE PACKAGE BODY "PKG_USER" AS
       --²éѯ¹ý³Ì
     PROCEDURE sp_userlist(cur_result OUT myrctype)
     IS
        sqlstr   VARCHAR2 (500);
     BEGIN
          OPEN cur_result FOR
             select * from t_user ;
    END sp_userlist ;
    END pkg_user;
5. C# ÖоͿÉÒÔµ÷ÓÃÕâ¸ö´æ´¢¹ý³ÌÁË.
    ÔÚOracle helper ÖÐÌí¼Ó
   
      public static void RunSql(string SqlString, CommandType cmdType, out DataTable dt)
        {
         
            OracleCommand cmd = CreateSqlCommand(SqlString, cmdType);
            OracleDataAdapter da;
     &n