create or replace procedure P_T_NON_RECURRING_CHAREG_XJS isso_charge_id number(6);
so_charge_name varchar2(250);
charge_level number(3);
so_eff_date date;
so_exp_date date;begin
charge_level := 0;
select so_charge_type_id,so_charge_name,eff_date,exp_date into so_charge_id,so_charge_name,so_eff_date,so_exp_date from so_charge_type@db_dqyy
end P_T_NON_RECURRING_CHAREG_XJS;
从提示最后一句不对Compilation errors for PROCEDURE BOSS_KC_DQ.P_T_NON_RECURRING_CHAREG_XJSError: PL/SQL: ORA-00933: SQL command not properly ended
Line: 13
Text: end P_T_NON_RECURRING_CHAREG_XJS;Error: PL/SQL: SQL Statement ignored
Line: 11
Text: select so_charge_type_id,so_charge_name,eff_date,exp_date into so_charge_id,so_charge_name,so_eff_date,so_exp_date from so_charge_type@db_dqyyError: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
begin case declare end exception exit for goto if loop mod
null pragma raise return select update while with
<an identifier> <a double-quoted delimited-identifier>
<a bind variable> << close current delete fetch lock insert
open rollback savepoint set sql execute commit forall merge
pipe
Line: 14Error: Hint: Value assigned to 'charge_level' never used in 'P_T_NON_RECURRING_CHAREG_XJS'
Line: 10
Text: charge_level := 0;
so_charge_name varchar2(250);
charge_level number(3);
so_eff_date date;
so_exp_date date;begin
charge_level := 0;
select so_charge_type_id,so_charge_name,eff_date,exp_date into so_charge_id,so_charge_name,so_eff_date,so_exp_date from so_charge_type@db_dqyy
end P_T_NON_RECURRING_CHAREG_XJS;
从提示最后一句不对Compilation errors for PROCEDURE BOSS_KC_DQ.P_T_NON_RECURRING_CHAREG_XJSError: PL/SQL: ORA-00933: SQL command not properly ended
Line: 13
Text: end P_T_NON_RECURRING_CHAREG_XJS;Error: PL/SQL: SQL Statement ignored
Line: 11
Text: select so_charge_type_id,so_charge_name,eff_date,exp_date into so_charge_id,so_charge_name,so_eff_date,so_exp_date from so_charge_type@db_dqyyError: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
begin case declare end exception exit for goto if loop mod
null pragma raise return select update while with
<an identifier> <a double-quoted delimited-identifier>
<a bind variable> << close current delete fetch lock insert
open rollback savepoint set sql execute commit forall merge
pipe
Line: 14Error: Hint: Value assigned to 'charge_level' never used in 'P_T_NON_RECURRING_CHAREG_XJS'
Line: 10
Text: charge_level := 0;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货