連接到:
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 過程已成功完成。
新聞熱點
疑難解答
