大神求解答

Merlin__ 2015-10-29 10:52:32

在存储过程创建的DW中，
存储过程：execute dbo.sp_whs_user_define_item_activity;1 @as_col_list='(cust_code)[cust_code] (cust_name)[cust_name] (warehouse_name)[whs_name] (gdw_no)[gdw_no] (gdw_uid)[gdw_uid] (gdw_delivery_by)[delivery_by] (receive_date)[recv_date] (receive_date_time)[recv_time] (gdw_vehicle_no)[car_no] (vessel_name)[vsl_name] (pkg_unit_desc)[pkg_unit_desc] (voyage)[voy_no] (gdw_cntr_no)[cntr_no] (gdw_seal_no)[seal_no] (gdw_cntr_size)[cntr_size] (gdw_load_code)[load_code] (gdw_dish_code)[dish_port] (job_no)[job_no] (gdw_hawb_hbl_no)[hbl_no] (gdw_mawb_mbl_no)[cbl_no] (eta)[eta] (gdw_issue_date)[issue_date] (lot_no)[lot_no] (gdw_remark)[gdw_remark] (etd)[etd] (cust_addr01)[cu_addr_01] (cust_addr02)[cu_addr_02] (cust_addr03)[cu_addr_03] (cust_addr04)[cu_addr_04] (cust_addr05)[cu_addr_05] (lot_no)[lot_no] (client_item_no)[client_item_no] (gdwlot_client_lot_no)[client_lot_no] (booked_pkg)[pkg] (pkg_unit)[pkg_unit] (booked_inpkg)[in_pkg] (in_pkg_unit)[in_pkg_unit] (booked_cbm)[cbm] (booked_kgs)[kgs] (width)[width] (whs_loc)[loc_code] (gdwlot_remark)[gdwlot_remark] (description)[descp] (marks)[marks] (height)[height] (item_no)[maitem_item_no] (length)[lenght]',@as_active_type='I',@as_with_sub_table='0000',@as_date_fm='1900-1-1',@as_date_to='2099-12-31',@as_pgdw_where = ' and 1=2',@as_pdo_where = ' and 1=2',@as_do_where = ' and 1=2',@as_display_doctype='0100',@as_pb_prt_arg='''901508000171'',''90F10000023'''
能运行
在PB中添加存储过程代码
execute dbo.sp_whs_user_define_item_activity;1 @as_col_list='(cust_code)[cust_code] (cust_name)[cust_name] (warehouse_name)[whs_name] (gdw_no)[gdw_no] (gdw_uid)[gdw_uid] (gdw_delivery_by)[delivery_by] (receive_date)[recv_date] (receive_date_time)[recv_time] (gdw_vehicle_no)[car_no] (vessel_name)[vsl_name] (pkg_unit_desc)[pkg_unit_desc] (voyage)[voy_no] (gdw_cntr_no)[cntr_no] (gdw_seal_no)[seal_no] (gdw_cntr_size)[cntr_size] (gdw_load_code)[load_code] (gdw_dish_code)[dish_port] (job_no)[job_no] (gdw_hawb_hbl_no)[hbl_no] (gdw_mawb_mbl_no)[cbl_no] (eta)[eta] (gdw_issue_date)[issue_date] (lot_no)[lot_no] (gdw_remark)[gdw_remark] (etd)[etd] (cust_addr01)[cu_addr_01] (cust_addr02)[cu_addr_02] (cust_addr03)[cu_addr_03] (cust_addr04)[cu_addr_04] (cust_addr05)[cu_addr_05] (lot_no)[lot_no] (client_item_no)[client_item_no] (gdwlot_client_lot_no)[client_lot_no] (booked_pkg)[pkg] (pkg_unit)[pkg_unit] (booked_inpkg)[in_pkg] (in_pkg_unit)[in_pkg_unit] (booked_cbm)[cbm] (booked_kgs)[kgs] (width)[width] (whs_loc)[loc_code] (gdwlot_remark)[gdwlot_remark] (description)[descp] (marks)[marks] (height)[height] (item_no)[maitem_item_no] (length)[lenght]',@as_active_type='I',@as_with_sub_table='0000',@as_date_fm='1900-1-1',@as_date_to='2099-12-31',@as_pgdw_where = ' and 1=2',@as_pdo_where = ' and 1=2',@as_do_where = ' and 1=2',@as_display_doctype='0100',@as_pb_prt_arg=:as_uid_list
添加参数值就会提示
select Error: failed to put data to safearray
错误
确信就是这里出了问题，求解

...全文