簡單的Oracle存儲過程的創建方法（菜鳥級）
2024-08-29 13:35:19
供稿：網友
連接到: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_LINE'6/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 過程已成功完成。
