我的写法是:
select nvl(fee_check_person,'') into cargo_person from agent.t_shp_main where ysno=ysnostr;
exception when no_data_found then null;报错:
Compilation errors for PROCEDURE YSCW.P_CARGO_DATAError: PLS-00103: Encountered the symbol "" when expecting one of the following:
begin case declare end 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
<a single-quoted SQL string> pipe
The symbol "" was ignored.
Line: 37
Text: select nvl(fee_check_person,'') into cargo_person from agent.t_shp_main where ysno=ysnostr;
select nvl(fee_check_person,'') into cargo_person from agent.t_shp_main where ysno=ysnostr;
exception when no_data_found then null;报错:
Compilation errors for PROCEDURE YSCW.P_CARGO_DATAError: PLS-00103: Encountered the symbol "" when expecting one of the following:
begin case declare end 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
<a single-quoted SQL string> pipe
The symbol "" was ignored.
Line: 37
Text: select nvl(fee_check_person,'') into cargo_person from agent.t_shp_main where ysno=ysnostr;
select max(nvl(fee_check_person,'')) into cargo_person from agent.t_shp_main where ysno=ysnostr;