连接到:
oracle9i enterprise edition release 9.2.0.1.0 - production
with the partitioning, olap and oracle data mining options
jserver 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_line'
6/1 pl/sql: statement ignored
sql> 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=3pl/sql 过程已成功完成。
新闻热点
疑难解答
