连接到:oracle9i enterprise edition release 9.2.0.1.0 – productionwith the partitioning, olap and oracle data mining optionsjserver release 9.2.0.1.0 – production
sql> create or replace procedure get_news( 2 aid in varchar2,atitle in varchar2) 3 as 4 begin 5 select * from cf_news 6 end; 7 /
警告: 创建的过程带有编译错误。
sql> create or replace procedure get_news( 2 aid in varchar2 ,atitle in varchar2) 3 as 4 beging 5 /
警告: 创建的过程带有编译错误。
sql> create or replace procedure get_news( 2 aid in varchar2) 3 as 4 begin 5 select * from cf_news; 6 end; 7 /
警告: 创建的过程带有编译错误。
sql> create or replace procedure get_news 2 as 3 begin 4 select * from cf_news; 5 end; 6 /
警告: 创建的过程带有编译错误。
sql> show errors;procedure get_news 出现错误:
line/col error——– —————————————————————–4/1 pls-00428: 在此 select 语句中缺少 into 子句sql> create or replace procedure get_news 2 as 3 aa number; 4 begin 5 select count(*) into aa from cf_news; 6 end; 7 /
过程已创建。
sql> create or replace procedure get_news 2 as 3 aa number; 4 begin 5 select count(*) into aa from cf_news; 6 dbms_outpub.put_line(aa=||aa); 7 end; 8 /
警告: 创建的过程带有编译错误。
sql> show errors;procedure get_news 出现错误:
line/col error——– —————————————————————–6/1 pls-00201: 必须说明标识符 dbms_outpub.put_line6/1 pl/sql: statement ignoredsql> create or replace procedure get_news 2 as 3 aa number; 4 begin 5 select count(*) into aa from cf_news; 6 dbms_output.put_line(aa=||aa); 7 end; 8 /
过程已创建。
sql> set serverout on;sql> execute get_news;aa=3
pl/sql 过程已成功完成。