以下的文章主要是對Oracle創建存儲過程的正確方法的介紹,其中包括有相關的連接,與在實際操中,那些的問題是值得我們注意的,以下就是具體方案的描述,希望在你今後的學習中會有所幫助。
連接到:
- 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 /
警告: Oracle創建的過程帶有編譯錯誤。
- 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 /
警告: Oracle創建的過程帶有編譯錯誤。
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 /
警告: Oracle創建的過程帶有編譯錯誤。
- SQL> show errors;
PROCEDURE GET_NEWS 出現錯誤:
- LINE/COL ERROR
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 /
過程已Oracle創建。
- SQL> set serverout on;
- SQL> execute get_news;
- aa=3