Çóoracle´æ´¢¹ý³Ì±¨´í¡°¶ÁÈ¡Î¥·´Ë³Ðò¡±½â¾ö°ì·¨

SQL code:

create or replace procedure P_Search_CRM_Barcode_State
as

var_barcode varchar2(50);--ÌõÂëʹÓÃ
cur_refcursor sys_refcursor;--½á¹û¼¯Ê¹ÓÃ

var_DEV_SUBTYPE VARCHAR2(20);
var_RESOURCE_INSTANCE_CODE VARCHAR2(50);
var_SALES_RESOURCE_NAME VARCHAR2(250);
var_STORAGE_NAME VARCHAR2(100);
var_CURR_STATE VARCHAR2(60);
var_DC_DEVICE_SCODE VARCHAR2(20);
var_NC_SALES_RESOURCE_ID VARCHAR2(50);
var_SALES_RESOURCE_ID NUMBER(9);
var_STORAGE_CODE VARCHAR2(21);
var_ATTR_ID number(9);
var_DN_NO VARCHAR2(20);
var_LAN_NAME VARCHAR2(40);
var_curr_state_temp varchar2(60);

--½¨Á¢Óαê
--1
cursor cur_barcode is
select * from xry_temp_barcode2;

--2
cursor cur_crm_barcode is
select * from xry_crm_barcode where dr=0
and state='000';

var_cur_temp1 xry_crm_barcode%rowtype;

begin

--½«Òª´¦ÀíµÄÌõÂë´æÈëÁÙʱ±íÀï
/*insert into xry_temp_barcode2
select distinct(vbarcode) from infl_nc_out_b
where dbizdate=to_char(to_date(sysdate-1),'yyyy-mm-dd');*/
--´ÓÁÙʱ±íÀïÈ¡³öÌõÂ룬ÔÙµ÷ÓÃcopy¿âµÄzczx_bss_ljj.get_device_inf
open cur_barcode;
loop
fetch cur_barcode into var_barcode;
exit when cur_barcode %NOTFOUND;