注册 登录
编程论坛 Oracle论坛

oracle存储过程转换为sqlserver

rainbowiris 发布于 2008-07-08 16:19, 1500 次点击
oracle包头信息如下:  
type rec_co_hc_no  is record (type          temp_inspection_data.type_list%type,
                                co            number(15,2),
                                hc            number(15,2),
                                no            number(15,2),
                                total_times  number(15),
                                total_vehicle number(15));
                                    
  type tbl_co_hc_no  is table of rec_co_hc_no;

包体信息如下;
procedure stat_gear_box_asm(v_start_date  in date,            
                              v_end_date    in date,            
                              v_time_stamp  in varchar2) is
    arr_co_hc_no            tbl_co_hc_no;    arr_onetimepassed        tbl_total;
    arr_passed              tbl_total;
  begin 
  .......
现在需将数据平台由oracle 10g转换为sql server 2005
请问这个存储过程我该怎么处理,
0 回复
1