在oracle存储过程中建立临时表,老提示:pls-00103

[free_cat_w]

create or replace
PROCEDURE CRT_GDMXZWJ
( p_dqdh IN VARCHAR2 DEFAULT 15
) AS
esql INTEGER;
eisam INTEGER;
v_cur_prcs_date DATE;
v_monthend_date DATE;
v_MonthEnd INTEGER;

BEGIN


-- exception
-- when others then
-- begin
-- dbms_output.put_line(''crt_gdmxzwj失败'');
-- rollback;
-- end;

begin
select cur_prcs_date into v_cur_prcs_date
from sys_ctrl;
end;
dbms_output.put_line(''begin''||v_cur_prcs_date);




create global temporary table tmp_loan
on commit delete rows as
select lnpa_loan_typ loan_typ, loan_no, ccy_ccy_cde, bhdt_bch_cde,
ctif_id_type, ctif_id_no, ctif_iss_ctry,
fixed_od_int_ind, main_gur_typ, repaym_typ,
rtty_rate_typ, rat_chg_opt, base_rate,sprd, int_adj_pct, int_start_dt,
last_setl_dt, rate_mode, orig_prcp, os_prcp, last_due_dt,
ls_appl_seq, instm_freq_unit_ty, grace_typ, od_grace_perd, sts
from loan
where SUBSTR(bhdt_bch_cde,1,2) = p_dqdh AND (sts = ''ACTV'' OR sts = ''SETL'')
order by lnpa_loan_typ, loan_no;
select count(*) into cnt from tmp_loan;
dbms_output.put_line(''cnt=''||cnt);

end crt_gdmxzwj;

[小当家e]

dbms_output.put_line(''begin''||v_cur_prcs_date); DBMS_OUTPUT.PUT_LINE('' CNT = '' || CNT); 改成单引号吧

[卖水果的net]

create global temporary table tmp_loan DDL 语句，在存储过程中，要使用动态语句。

[lyc0001123]

双引号改成单引号

[free_cat_w]

谢谢各位啦！！